Looking Forward to Postgres 19: It's About Time
Key takeaways
- NEW pg Edge AI DBA Workbench for 24x7 monitoring and management of ANY Postgres v14+.
- Maybe it's the price of a product before the holiday sale kicked in, or which department an employee belonged to before that reorg nobody asked for.
- The SQL:2011 standard formalized a proper solution over a decade ago with temporal tables.
NEW pg Edge AI DBA Workbench for 24x7 monitoring and management of ANY Postgres v14+. LEARN MORE
Get Started Free▾Products Solutions Resources Company Contact Get Started Free▾< Blog Home Looking Forward to Postgres 19: It's About Time Shaun Thomas|June 12, 2026Recently, a new type of question has entered the database arena: what did this data look like last Tuesday? Maybe it's the price of a product before the holiday sale kicked in, or which department an employee belonged to before that reorg nobody asked for. Short of adding an entire audit trigger system, how can we know what data looked like before and after a change at that exact date?
The SQL:2011 standard formalized a proper solution over a decade ago with temporal tables. Other database engines adopted pieces of it relatively quickly. Characteristically, Postgres took its time. But Postgres 19 is finally bringing native temporal table support to the party — and it's been well worth the wait.