PostgreSQL 14 Beta Released With More Performance Improvements
Written by Michael Larabel in Programming on 20 May 2021 at 11:44 AM EDT. 15 Comments
PROGRAMMING --
PostgreSQL developers continue working on juicing the maximum performance possible out of this popular open-source SQL database server.

Like with recent major feature releases of PostgreSQL, version 14 is bringing more significant work in this department. Today's beta one announcement notes, "This release has significant improvements in transaction throughput for PostgreSQL systems that have large numbers of connections to the database, regardless if they are in an active or idle state. PostgreSQL 14 also contains additional gains in reducing B-tree indexing overhead, including reducing the bloat on tables with frequently updated indexes. GiST indexes can now presort data during their build process, allowing both for faster index creation and smaller indexes...There are many improvements to query parallelism in PostgreSQL 14. In addition to overall performance improvements for parallel sequential scans, the RETURN QUERY directive in PL/pgSQL can now execute queries with parallelism. REFRESH MATERIALIZED VIEW can now use query parallelism as well...PostgreSQL 14 also introduces the ability to leverage query parallelism when querying remote databases using foreign data wrappers."

In addition to those performance enhancements and other changes in the name of better performance, PostgreSQL 14 is introducing a new multi-range type, VACUUM handling improvements, logical replication improvements, some minor security enhancements, and other improvements.

More details on all of the feature work building up for PostgreSQL 14.0 can be found via today's beta 1 announcement.
Related News
About The Author
Author picture

Michael Larabel is the principal author of Phoronix.com and founded the site in 2004 with a focus on enriching the Linux hardware experience. Michael has written more than 20,000 articles covering the state of Linux hardware support, Linux performance, graphics drivers, and other topics. Michael is also the lead developer of the Phoronix Test Suite, Phoromatic, and OpenBenchmarking.org automated benchmarking software. He can be followed via Twitter or contacted via MichaelLarabel.com.

Popular News This Week