PostgreSQL 19.0 Release Notes
Summary
PostgreSQL 19.0 released with new features including REPACK for disk space reclamation, planner enhancements via pg_plan_advice and pg_stash_advice, and performance improvements such as parallel autovacuum and faster index checks. It introduces logical replication without restart when wal_level=replica, read-your-writes on standbys via WAIT, and more. Migration notes cover upgrading guidance and compatibility changes such as password expiration warnings, MD5 password warnings, RADIUS removal, and various config changes.