PostgreSQL 12 Due Out Tomorrow With Better Performance

Written by Michael Larabel in Free Software on 2 October 2019 at 06:58 AM EDT. 13 Comments
FREE SOFTWARE
Tomorrow is when PostgreSQL 12.0 should meet the world for this popular open-source SQL database server.

PostgreSQL 12.0 furthers their never-ending quest for better performance. Some of the optimizations for PostgreSQL 12 include better space utilization and read/write performance for B-tree indexes, better partitioning performance, automatic inlining of common table expressions, reduced WAL overhead, and other work.

PostgreSQL 12 also allows REINDEX CONCURRENTLY to rebuild an index without blocking writes, there is now support for the SQL/JSON path language, stored generated columns support, new authentication features, and other enhancements.

More details on what to expect from the imminent PostgreSQL 12.0 release can be found via the release notes. We'll be firing up some EPYC vs. Xeon SQL database benchmarks with PostgreSQL 12 upon its official release.
Related News
About The Author
Michael Larabel

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, LinkedIn, or contacted via MichaelLarabel.com.

Popular News This Week