PostgreSQL 19
|
PostgreSQL 19 was released on November 19, 2026, featuring a new REPACK command for disk space reclamation, improved query performance through automatic I/O worker scaling and faster foreign-key checks, and enhanced logical replication capabilities including sequence value replication and "read-your-writes" consistency on standbys. The release includes several breaking changes, such as removal of RADIUS authentication support, enforcement of standard_conforming_strings, and new password expiration warnings, requiring users to migrate data using pg_dumpall, pg_upgrade, or logical replication.