Time Traveling PostgreSQL

October 21–24
Level: Intermediate

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 shown live on stage with examples and will be available afterwards for everyone under PostgreSQL license..

Back

Join Us For PostgreSQL Conference Europe 2025

October 21–24 2025

Radisson Blu Latvija, Riga, Latvia