PostgreSQL 19 officially released, performance optimization and distributed data processing capabilities further enhanced

📅 2026-11-20

Abstract:

The open source database PostgreSQL 19.0 is now officially released. The development team said that this version brings a number of updates to simplify workload management, improve distributed data processing, and improve performance and developer experience. Previously, the release of PostgreSQL 19 was delayed for several weeks due to a large number of defect reports and security issues generated by AI and large language models.

image.webp

PostgreSQL 19.0 continues to strengthen its positioning as "the world's most advanced open source database." The new version introduces support for logical replication of sequence values, which helps improve data processing capabilities in distributed environments. It also simplifies the workload management mechanism, making the database easier to deploy and maintain in complex application scenarios.

At the performance level, the automatic cleaning mechanism of PostgreSQL 19 can now use parallel worker processes to perform cleaning operations on indexes, thereby improving the maintenance efficiency of large databases. The performance of foreign key checking has also been improved, and in the default "worker" input and output mode, the system can automatically adjust the number of input and output worker processes to better adapt to different loads.

In terms of query capabilities, the new version improves the query performance of external tables and adds support for the INSERT ... ON CONFLICT DO SELECT syntax, providing developers with a more flexible expression when dealing with insertion conflicts and data reading. The server side has also added support for Server Name Indication (SNI), which helps with connection identification and routing in more complex network and hosting environments.

It is worth noting that PostgreSQL 19 turns off just-in-time compilation (JIT) support by default. The development team believes that the cost estimates previously used to determine when to enable JIT are not reliable enough, so the feature is no longer enabled by default. However, for users who need to run a large number of large analysis queries, officials still recommend manually enabling JIT to gain potential performance gains.

PostgreSQL 19.0 is now available for download through official channels. Relevant performance benchmarks will also be released later, at which time the performance of the new version in actual workloads can be further evaluated.

Learn more:

https://www.postgresql.org/about/news/postgresql-19-released-3449/

Related tags

Related articles

Comments

0/500
Captcha (click to refresh)
No comments yet