PostgreSQL 14.0 Released With More Performance Improvements
Written by Michael Larabel in Programming on 30 September 2021 at 09:19 AM EDT. 16 Comments
PROGRAMMING --
PostgreSQL 14.0 is now officially available as the latest version of this widely-used, open-source SQL server.

As with most major PostgreSQL releases, PostgreSQL 14 brings more performance improvements. In particular there are new optimizations around parallel queries, heavily-concurrent workloads, partitioned tables, logical replication, and vacuuming. PostgreSQL 14 also has B-tree index updates so they are managed more efficiently. PostgreSQL 14's libpq library also now allows for pipelining multiple queries to improve throughput over high latency connections.

PostgreSQL 14.0 also allows for stored procedures to return data via OUT parameters, support for SQL-standard SEARCH and CYCLE options, range types now have multi-ranges support, VACUUM is now more aggressive, and other additions.

More details on this morning's PostgreSQL 14.0 release via PostgreSQL.org and the release notes.

Our PostgreSQL / pgbench test profile will be updated shortly for delivering PostgreSQL 14 benchmarks.
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