Conference Schedule - FOSDEM PGDay 2019

Periods and System Versioned Tables

Date: 2019-02-01
Time: 16:30 - 17:20
Room: Hotel

SQL:2011 introduced the concept of a Period. These can be used for many things but the most well-known application is system versioned tables where all changes to a table are recorded and can be summoned via SQL.

PostgreSQL is one of the last databases to implement this feature. In this presentation we will see the many different ways periods can be used, and talk about the current status of their implementation.


Vik Fearing