PostgreSQL 19 Released With More Performance Improvements

After running weeks behind schedule due to PostgreSQL developers being overwhelmed by AI/LLM-led bug reports and security issues, PostgreSQL 19.0 managed to finally ship today. PostgreSQL 19.0 is now available for what the developers claim to be "the world's most advanced open source database." PostgreSQL 19.0 brings updates to simplify workload management, improve distributed data handling with logical replication of sequence values and other changes, and also a number of developer improvements and performance enhancements. Some interesting specifics include PostgreSQL's autovacuum can now vacuum indexes using parallel workers, improved queries on foreign tables, support for the INSERT ... ON CONFLICT DO SELECT syntax, improved performance of foreign key checks, automatically adjusting the number of I/O workers when in the default "worker" I/O method, server-side support for SNI, and more. PostgreSQL also now disables its Just-In-Time (JIT) compilation support by default as their cost estimates for when it should be used were considered unreliable. Those running many large analytical queries are encouraged to manually enable the JIT. Downloads and more details on the PostgreSQL 19.0 release via PostgreSQL.org. New PostgreSQL benchmarks of the 19.0 release will be coming up on Phoronix.

Original Source

Read the full article at Phoronix →

KhanList aggregates and links to publicly available news content. We do not host full articles from third-party sources. Always verify important information with original sources.