Tech Radar: PostgreSQL 19 GA — The Production Upgrade Guide for 17/18 Fleets
Tech Radar: PostgreSQL 19 GA — The Production Upgrade Guide for 17/18 Fleets Answer-first: PostgreSQL 19 general availability is scheduled for November 19, 2026 — the RC2 announcement names that date explicitly, “barring issues requiring delay.” The release ships 212 features, and four of them change production operations directly: in-core REPACK (CONCURRENTLY) (bloat removal without an exclusive lock, replacing the external pg_repack dependency), parallel autovacuum with per-table worker tuning and a scoring-based prioritization system, auto-scaling async I/O workers (io_min_workers/io_max_workers) building on the PostgreSQL 18 AIO subsystem, and the WAIT command for read-your-writes on standbys. Before planning the upgrade, note what landed on November 12: point releases for every supported branch fixing 52 security vulnerabilities (including pg_restore and pg_dump code-execution CVEs rated 8.8), PostgreSQL 14 reaching end-of-life with 14.25 as its final release, and a set of post-update reindex and re-backup requirements. This edition is the day-one playbook: what actually ships, what breaks, and the exact pg_upgrade sequence for 17/18 fleets. ...