Schedule - PGDay/MED 2024

Time Traveling PostgreSQL

Date: 2024-12-05
Time: 14:05–14:55
Room: Positano

Until PostgreSQL 6.2 had time travel implemented in its core. It has been removed in PostgreSQL 6.3.

But it can be implemented with PostgreSQL methods by adding some triggers. As that can result in big tables, when there are many updates, this can be solved with partitioned tables.

In this talk I would explain what is needed and how to implement time travel into PostgreSQL again. The code to implement is is shown live on stage with examples and will be available afterwards for everyone.

Speaker

Stefanie Janine Stölting