PostgreSQL 19 Beta 1 Debuts with Async I/O Scaling, SQL/PGQ, and Parallel Vacuum

The first beta of PostgreSQL 19 introduces significant performance improvements including automatic scaling of async I/O workers, parallel autovacuum, and up to 2x faster inserts with foreign key checks. Developer experience enhancements include SQL/PGQ property graph queries, GROUP BY ALL, expanded jsonpath functions, and upsert RETURNING support. On the operations side, the release adds SNI-based TLS certificates, per-lock statistics, recovery monitoring views, and a new REPACK command for nonblocking table rebuilds. The PostgreSQL Global Development Group encourages community testing to help stabilize the release ahead of general availability.