Conference Schedule - PGConf.EU 2022

Changelog vs Two-dimensional time - what works better?

Date: 2022-10-26
Time: 11:10–12:00
Room: Berlin 2+3
Level: Intermediate

Almost nobody objects to the idea of keeping the changelog for their data. After all, we want to know who changed our data, when, and why. Managers won't care about the extra disk volume required most of the time. However, a suggestion of implementing asserted versioning (a two-dimensional time concept) is always met with resistance. All of a sudden, the extra disk seems too much, the application performance is at risk, and the benefits are non-obvious.

In this presentation, we will prove that these fears are mostly unfounded. In addition, we will demonstrate that there is an easy and efficient way to build as many changelogs as you would like from bitemporal tables. You can have both time travel and changelogs from one data set. You can view the data when an error occurred and after it was corrected and observe the impact of this error on reporting.


Henrietta Dombrovskaya