
PostgreSQL 19 released with overhauled table maintenance and faster workloads
The PostgreSQL Global Development Group has announced the release of PostgreSQL 19, the latest version of the advanced open source database. The release responds to rapidly rising mission-critical usage by simplifying administration and development for workloads at scale. Its most consequential change is the new REPACK (CONCURRENTLY) command, which reclaims table bloat and can reorder data to match an index without blocking reads or writes, a task previously handled by VACUUM FULL and CLUSTER, which locked tables during cleanup. Administrators also gain finer control over query performance through the new pg_plan_advice extension, which can stabilize query plans and fix slow ones without changing the application.
“For over 30 years, the global open source community has built PostgreSQL into a database that organizations trust with their most critical data”, said Jonathan Katz, a member of the PostgreSQL core team. “PostgreSQL 19 continues that commitment to reliability, giving users new ways to manage their workloads without disruption and to build applications that span multiple systems.” Performance gains are a recurring theme throughout the release: foreign key check improvements made bulk inserts nearly twice as fast in testing, new planner optimizations convert NOT IN clauses into efficient anti-joins and perform eager aggregation before joins, and the asynchronous I/O subsystem introduced in PostgreSQL 18 now automatically adjusts the number of I/O workers between new minimum and maximum settings.
The release also targets developers and distributed deployments. New features include INSERT ... ON CONFLICT DO SELECT to simplify the common “get or create” pattern, JSON output for COPY, and “read-your-writes” consistency on standby servers via the new WAIT FOR LSN command, which lets an application read data it just wrote on the primary. Logical replication becomes easier to adopt, the WAL level now rises automatically when the first logical replication slot is created, no server restart required, and sequences can finally be replicated themselves. On the security front, PostgreSQL 19 adds server-side TLS SNI support mapped through a new pg_hosts.conf file, warns on use of the deprecated md5 password authentication, drops RADIUS authentication entirely, and disables just-in-time compilation (JIT) by default after its cost estimates proved unreliable.




Comments
Free Software like PostgreSQL are beautiful