PostgreSQL 19 Interactive Tour: SQL/PGQ Graph Queries, Temporal Updates, and More

PostgreSQL 19 is in beta, with GA expected around September or October 2026. This hands-on companion to the official release notes turns selected new features into runnable examples against beta 3. Highlights include SQL/PGQ property graph queries, temporal UPDATE/DELETE with FOR PORTION OF, upsert's new ON CONFLICT DO SELECT, window functions with IGNORE NULLS, the unified REPACK command, autovacuum priorities, and more. Note: merge/split partitions were reverted after beta 3 and won't ship in 19.