Implementing Temporal Features in PostgreSQL: SQL Standard and Beyond
summary
A prototype extension pg_bitemporal implements bitemporal storage on PostgreSQL using GIST exclusion index for non‑overlapping business keys and efficient temporal searches, and provides user functions for bitemporal DML (INSERT, UPDATE, REPAIR, INACTIVATE, DELETE). It stores history and current state in one table with good performance, but it lacks no SQL syntax extension for temporal queries, explicit SYSTEM_TIME support, and standardized full temporal joins and period aggregates.
AI-written summary · about
chapters (6)
- 0:00Introduction
- 0:58Temporal DB Basics
- 6:24Temporal Features in the SQL Standard
- 12:32PostgreSQL Support for Temporal Data
- 14:19Bitemporal Implementation
- 19:27What is Still Missing?
related talks
46mEnhancements to the bitemporal model support: integrity constraints
46mIntro to Postgres Hacking via Temporal Tables
01h 03mTemporal Database Demo
24mPostgreSQL Design Patterns
53mEfficient Time Series with PostgreSQL
42mBack to the Future! Time Travel with Bitemporal Databases
39mTimescaleDB: Re-engineering PostgreSQL as a time-series database
39mPrinciples of Reporting Systems: It's About Time we Talked About Bitemporality