Infrastructure
Looking forward to PostgreSQL 19
- 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.