Schedule - PGDay Chicago 2024

Temporal Features in PostgreSQL: SQL Standard and Beyond

Date: 2024-04-26
Time: 08:50–09:35
Room: Hub2
Level: Intermediate

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.

In this talk, we briefly describe temporal data concepts. We then discuss relationships between SQL standards and the implementation of bi-temporal data in PostgreSQL. We further discuss how advanced temporal features, such as multiple time dimensions, are provided on top of standard basic features.

Speaker

Henrietta Dombrovskaya