PostgreSQL 12 Released
Written by Kay Ewbank   
Monday, 14 October 2019

PostgreSQL 12 has been released with improvements to partitioning and handling of btrees, along with support for multi-column most-common-value statistics.

PostgreSQL is an open source database system that was originally created at the University of California, Berkeley. It is now maintained and developed by the PostgreSQL Global Development Group, a coalition of many companies and individual contributors. PostgreSQL runs on all major operating systems, has been ACID-compliant since 2001, and has add-ons such as the PostGIS geospatial database extender.

postgresqlsqThe developers say this release offers notable improvements to query performance, particularly over larger data sets. It also offers SQL/JSON path expression support, optimizations for how common table expression (WITH) queries are executed, and generated columns.

PostgreSQL 12 provides significant performance and maintenance enhancements to its indexing system and to partitioning. B-tree Indexes which are used as standard in PostgreSQL have been optimized to deal better with where the indexes are frequently modified.

Queries on partitioned tables have also been improved, especially tables with thousands of partitions that only need to retrieve data from a limited subset. Adding data to such tables is also faster, and there's a new option to attach a new partition to a table without blocking queries.

Elsewhere in indexing, Create Statistics now supports most-common value (MCV) statistics to help generate better query plans when using columns that are nonuniformly distributed.

The Just in Time compilation using LLVM that was added in PostgreSQL 11 is now enabled by default to improve performance in situations including the execution of expressions in Where clauses.

New in this release is the ability to run queries over JSON documents using JSON path expressions, and the ability to inline With queries. PostgreSQL 12 also introduces generated columns that have their values computed from the contents of other columns in the same table.

The final main improvement is to authentication, with the addition of support for both client and server-side encryption for authentication over GSSAPI interfaces, as well as the ability for PostgreSQL to discover LDAP servers if PostgreSQL is compiled with OpenLDAP. PostgreSQL 12 also now supports a form of multi-factor authentication whereby the server can require an authenticating client to provide a valid SSL certificate with their username, along with requiring a separate authentication method.



More Information

PostgreSQL website

Related Articles

Aurora Serverless PostgreSQL Generally Available

The Enduring Influence Of Postgres

PostgreSQL Improves Declarative Partitioning 

PostgreSQL Adds Parallel Query Support

PostgreSQL Version 9.5

PostgreSQL 9.4 Released

PostgreSQL Plus Cloud Database


To be informed about new articles on I Programmer, sign up for our weekly newsletter, subscribe to the RSS feed and follow us on Twitter, Facebook or Linkedin.


GitLab 14 Offers DIY DevOps Alternative

GitLab, the web-based repository manager for Git, has been updated with improvements designed to give teams an alternative to maintaining DIY DevOps chains. GitLab supports concurrent devops and issue [ ... ]

World Emoji Day Chooses Syringe To Sum Up 2021

This year's World Emoji Day, celebrated this week, saw the syringe emoji winning the award for the 'Most 2021' emoji, narrowly beating the microbe emoji among voters on Twitter.

More News





or email your comment to: