Looking Forward to Postgres 19: It's About Time
Summary
Postgres 19 introduces native application-time temporal tables with range-based data tracking, eliminating the need for external extensions for temporal features. The article compares traditional approaches (using btree_gist and manual range handling) with the new native features, demonstrates practical usage (FOR PORTION OF, WITHOUT OVERLAPS, and DATERANGE), and discusses temporal foreign keys and remaining gaps like system-time support. It frames this as a significant step for Postgres and invites experimentation in test environments.