PostgreSQL 14.0 Released With More Performance Improvements

guest · Oct 3, 2021

PostgreSQL 14.0 Released With More Performance Improvements
September 30, 2021
https://www.phoronix.com/scan.php?page=news_item&px=PostgreSQL-14

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.
Click to expand...

PostgreSQL 14.0 (September 30, 2021)
Website
Announcement
Download

The PostgreSQL Global Development Group today announced the release of PostgreSQL 14, the latest version of the world’s most advanced open source database.

PostgreSQL 14 brings a variety of features that help developers and administrators deploy their data-backed applications. PostgreSQL continues to add innovations on complex data types, including more convenient access for JSON and support for noncontiguous ranges of data. This latest release adds to PostgreSQL's trend on improving high performance and distributed data workloads, with advances in connection concurrency, high-write workloads, query parallelism and logical replication.
Click to expand...

Log in or Sign up

PostgreSQL 14.0 Released With More Performance Improvements

guest Guest

Log in or Sign up

PostgreSQL 14.0 Released With More Performance Improvements

guest Guest

Useful Searches