PostgreSQL 19, released November 19, 2026, focuses on reclaiming space, improving query performance, and expanding replication and maintenance capabilities. Its new REPACK command reorganizes tables and recovers disk space, with a concurrent mode that keeps reads and writes available. Logical replication can be enabled without a restart when WAL is set to replica, and sequence values can now be replicated. A new WAIT command supports read-your-writes consistency on standbys. Other changes include parallel index autovacuum, automatic adjustment of I/O worker counts, faster foreign-key checks, and optimizer improvements that can reduce work in joins and aggregates. Performance gains also target COPY, sorting, compression, and index maintenance.
Moving from an earlier major version requires a dump and restore, pg_upgrade, or logical replication. Compatibility changes include forcing standard_conforming_strings on, removing RADIUS authentication and the MULE_INTERNAL encoding, and rejecting carriage returns or line feeds in database, role, and tablespace names. MD5 password authentication now warns users because the method is deprecated, while JIT compilation is disabled by default. Some existing indexes and stored text-search data may need rebuilding or recomputation after an upgrade, especially where locale behavior has changed; pg_upgrade also rejects clusters with affected inet/cidr indexes. Other behavior changes include empty-array results replacing NULL for a particular json_array() call and stricter read-only enforcement for postgres_fdw sessions.
Summary generated by AI from the linked article. hn.today is not affiliated with Hacker News or Y Combinator.