PostgreSQL 19 Beta 1 released: parallel autovacuum, REPACK, SQL/PGQ

On June 4, 2026, the PostgreSQL Global Development Group released PostgreSQL 19 Beta 1, previewing features ahead of general availability expected around September–October 2026.

Key points

• Performance & maintenance: autovacuum can now use parallel workers (autovacuum_max_parallel_workers); a new REPACK command (with CONCURRENTLY) rebuilds tables with less locking; inserts are up to 2x faster when foreign-key checks are present.
• I/O & planner: io_method=worker auto-scales via io_min_workers/io_max_workers; a new pg_plan_advice extension stabilizes planner decisions; plus eager aggregation and anti-join optimizations.
• SQL experience: SQL/PGQ property graph queries; GROUP BY ALL; INSERT ... ON CONFLICT DO SELECT; and WAIT FOR LSN for read-your-writes patterns on replicas.
• Security & observability: server-side SNI via pg_hosts.conf; warnings after md5 authentication; new pg_stat_lock and pg_stat_recovery views.
• Notable changes: JIT is now disabled by default; default_toast_compression defaults to lz4; RADIUS authentication support is removed.