Looking ahead to PostgreSQL 19

Category: Infrastructure
Status: developing
Sources: PostgreSQL 19 Beta 1, Snowflake engineering, HN discussion
Summary: A Snowflake engineering post walks through PostgreSQL 19 features now in the Beta 1 cycle, reaching the Hacker News front page (203 points). Highlighted items include REPACK CONCURRENTLY for lock-free table reorganization, SQL/PGQ property-graph queries, dynamic partition merge and split, logical-replication sequence synchronization, parallel autovacuum with per-table configuration and a new scoring view, INSERT...ON CONFLICT DO SELECT...RETURNING, GROUP BY ALL, and window-function IGNORE NULLS. PostgreSQL 19 GA is expected in the autumn 2026 window.
Why it matters: REPACK CONCURRENTLY, parallel autovacuum, and the temporal and upsert SQL additions target long-standing operational pain in large Postgres deployments.
Follow-up: Watch for Beta 2 and the RC schedule ahead of GA, and PostgreSQL 14 end of life on 2026-11-12.