PostgreSQL 19 focuses on making large, mission-critical database workloads easier to manage without disruption, while improving query control and application development. Its new REPACK command reclaims table bloat and can reorder data, with a concurrent mode that avoids blocking reads and writes; the older VACUUM FULL and CLUSTER remain available. The pg_plan_advice and pg_stash_advice extensions help stabilize or adjust query plans, including applying fixes by query identifier. Autovacuum gains parallel index processing and improved table prioritization, alongside new monitoring views and more detailed reporting of I/O and write-ahead logging.
The release also strengthens replication and distributed use: logical replication can initialize without a server restart, sequence values can be published, and standby sessions can wait for a specified log sequence number before reading, enabling read-your-writes consistency. Developers gain INSERT ... ON CONFLICT DO SELECT for get-or-create workflows, JSON output from COPY, expanded SQL/JSON string functions, and window functions that can ignore NULLs. Performance improvements include faster foreign-key checks, planner optimizations, and dynamically adjusted asynchronous I/O workers. Other notable changes add hostname-based TLS certificates, warn about deprecated MD5 authentication, remove RADIUS authentication, disable JIT by default, and prefer LZ4 TOAST compression when supported. These changes target operational reliability as well as convenience and speed.
Summary generated by AI from the linked article. hn.today is not affiliated with Hacker News or Y Combinator.