Implementing Temporal Features in PostgreSQL: SQL Standard and Beyond | Citus Con 2023

Video of a conference talk about the temporal data concept—and the relationships between SQL standards and the implementation of bi-temporal data in PostgreSQL. This talk was delivered by Henrietta Dombrovskaya at Citus Con: An Event for Postgres 2023. In this talk, Henrietta also discusses how advanced temporal features, such as multiple time dimensions, are provided on top of standard basic features.

Since 2011 the SQL standard has defined a set of features providing essential support for temporal data. These features include periods, row versioning, and syntax extensions for SQL commands. Some of these features already exist in recent releases of PostgreSQL. In addition, PostgreSQL provides several tools, such as GIST indexes, that are not explicitly related to temporal data but can make the implementation of temporal data efficient.

Henrietta Dombrovskaya (Hettie) is a database researcher and developer with 40 years of academic and industrial experience. Hettie holds a PhD in Computer Science from the University of Saint Petersburg, Russia. Hettie is a Database Architect at DRW; a Local Organizer of the Chicago PostgreSQL User Group; an active community member and frequent speaker at PostgreSQL conferences; and an author of the PostgreSQL Query Optimization book.

► Video bookmarks:
⏩ 00:00 Introduction
⏩ 00:58 Temporal DB Basics
⏩ 06:24 Temporal Features in the SQL Standard
⏩ 12:32 PostgreSQL Support for Temporal Data
⏩ 14:19 Bitemporal Implementation
⏩ 19:27 What is Still Missing?

✅ Learn more:

📌 Let’s connect:  

#CitusCon #PostgreSQL #Database