• Category: Infrastructure
  • Status: discussion
  • Sources: pgEdge blog, HN discussion
  • Summary: A widely read write-up covers PostgreSQL 19 bringing application-time temporal table support, the half of the SQL:2011 bi-temporal model that Postgres had not yet implemented. PostgreSQL 19 Beta 1 shipped 2026-06-04 and also adds parallel autovacuum, INSERT ... ON CONFLICT DO SELECT, SQL/PGQ graph queries, and REPACK, with JIT disabled by default.
  • Why it matters: PostgreSQL 19 GA is expected in the autumn, and native application-time temporal tables change how teams model history and audit data instead of hand-rolling validity columns.
  • Follow-up: Track Beta 2, the RC schedule, and GA.

Send feedback on this story