PostgreSQL 19 Beta Introduces SQL Graph Queries and Concurrent Table Repacking

PostgreSQL 19 Beta 1 has been released, with general availability expected in September. Key features include native SQL Property Graph Queries (SQL/PGQ) enabling graph queries over relational tables without a separate graph database, and a new REPACK CONCURRENTLY command for online table rebuilds without downtime. Performance highlights include up to 2x faster inserts with foreign key checks, anti-join optimizations, incremental sorts, and eager aggregation. Logical replication gains automatic sequence synchronization and can now be enabled without a server restart. The new WAIT FOR LSN feature lets read replicas pause until caught up to a specific write position. Other notable changes include parallel autovacuum, automatic I/O worker scaling, pg_plan_advice for persisting query planner decisions, and JIT compilation disabled by default. AWS has made Beta 1 available in the RDS Preview Environment.