PostgreSQL - widely-used, open-source SQL server

guest · Oct 13, 2022

PostgreSQL 15 Released With Better Sort Performance, Supports LZ4 & Zstd Compression
by Michael Larabel @michaellarabel - October 13, 2022

PostgreSQL 15 is out today as the newest major feature release to this leading open-source database solution.

As for the performance work to find with PostgreSQL 15, today's release announcement notes:

In this latest release, PostgreSQL improves on its in-memory and on-disk sorting algorithms, with benchmarks showing speedups of 25% - 400% based on which data types are sorted. Using row_number(), rank(), dense_rank(), and count() as window functions also have performance benefits in PostgreSQL 15. Queries using SELECT DISTINCT can now be executed in parallel.

Building on work from the previous PostgreSQL release for allowing async remote queries, the PostgreSQL foreign data wrapper, postgres_fdw, now supports asynchronous commits.
Click to expand...

PostgreSQL 15 delivers on a number of performance improvements, finally adds a "MERGE" command, enables Zstd and LZ4 compression support, and has a number of other features.
Click to expand...

PostgreSQL 15.0 Released (October 13, 2022)
Website
Announcement
Download

October 13, 2022 - The PostgreSQL Global Development Group today announced the release of PostgreSQL 15, the latest version of the world’s most advanced open source database.

PostgreSQL 15 builds on the performance improvements of recent releases with noticeable gains for managing workloads in both local and distributed deployments, including improved sorting. This release improves the developer experience with the addition of the popular MERGE command, and adds more capabilities for observing the state of the database.

"The PostgreSQL developer community continues to build features that simplify running high performance data workloads while improving the developer experience," said Jonathan Katz, a PostgreSQL Core Team member. "PostgreSQL 15 highlights how, through open software development, we can deliver to our users a database that is great for application development and safe for their critical data."
Click to expand...

Log in or Sign up

PostgreSQL - widely-used, open-source SQL server

guest Guest

Log in or Sign up

PostgreSQL - widely-used, open-source SQL server

guest Guest

Useful Searches