PostgreSQL 12 Beta Released With Performance Improvements
Written by Michael Larabel in Free Software on 23 May 2019 at 09:12 AM EDT. 14 Comments
FREE SOFTWARE --
Out today is the first beta of the upcoming PostgreSQL 12.0 database server.

The PostgreSQL 12.0 beta features performance improvements on many different fronts, including for standard B-tree indexes. PostgreSQL 12.0 also enhances the performance by allowing to rebuild indexes concurrently, extended various indexing mechanisms, lower overhead for the write-ahead log, better performance when processing tables with thousands of partitions, and various other optimizations.

PostgreSQL 12 also now supports automatically inlining common table expressions if they are not recursive nor other complications. PostgreSQL 12.0 also adds the ability to execute JSON path queries, case-insensitive and accent-insensitive comparisons for collations, supports the creation of generated columns, a new pluggable table storage interface, and various other additions.

More details on the PostgreSQL 12.0 Beta release via today's announcement on PostgreSQL.org.
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 10,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.

Related Free Software News
Popular News This Week