PostgreSQL 19 Beta 1 released with parallel autovacuum and graph query support

Category: Languages
Status: confirmed
Sources: PostgreSQL announcement, Neon features overview
Summary: PostgreSQL 19 Beta 1 released 2026-06-04. Key additions: parallel autovacuum workers with configurable autovacuum_max_parallel_workers; INSERT ... ON CONFLICT DO SELECT for atomic get-or-create semantics; SQL/PGQ property graph query support; REPACK command for online table maintenance; io_method=worker auto-scaling I/O workers; JIT disabled by default; native JSON output for COPY TO; logical replication sequence support. GA is targeted for September/October 2026.
Why it matters: Parallel autovacuum directly addresses high-write-rate table bloat that has been a primary scaling pain point; beta testing now identifies regressions before the September freeze.