PostgreSQL 14 brings performance boosts

PostgreSQL 14, the most recent version of the common open source databases, has arrived, with abilities targeted on functionality, advanced facts kinds, and distributed facts workloads.

Posted on September 30, PostgreSQL 14 can be downloaded from postgresql.org.

For workloads that use numerous connections, the PostgreSQL 14 enhance has attained a doubling of functionality on some benchmarks. Significant workloads, and workloads with numerous modest produce operations, also advantage from the new ability to pipeline queries to a databases, which can increase functionality more than large-latency connections. This customer-facet function can be utilised with any modern-day PostgreSQL databases with the version 14 customer or a customer driver created with version 14 of libpq.

For distributed workloads, use of sensible replication can stream in-development transactions to subscribers, with functionality positive aspects for implementing substantial transactions. And international facts wrappers, for doing work with federated workloads across PostgreSQL and other databases, now can leverage query parallelism in PostgreSQL 14.

Somewhere else in PostgreSQL 14:

  • Query arranging and execution have been enhanced. Improved assist for query parallelism includes greater functionality of parallel sequential scans. Queries employing nested loop joins may possibly advantage by means of further caching in PostgreSQL 14.
  • Selection kinds now assist contiguous ranges by means of a “multirange” facts kind. A multirange is an requested record of ranges that do not overlap, allowing developers to produce easier queries to function with advanced assortment sequences.
  • JSON facts can be accessed employing subscripts.
  • Functionality has been enhanced in the vacuuming technique for databases routine maintenance. Optimizations include things like cutting down the overhead of B-trees.
  • Stored treatments allowing for transaction manage in a block of code now can return facts by employing OUT parameters.
  • Prolonged statistics now can be utilised for expressions.
  • Assigning study-only and produce-only privileges to people on tables, views, and schemas has been produced less complicated by means of pg_study_all_facts and pg_produce_all_facts predefined roles.
  • Requirements-compliant SCRAM-SHA-256 password management and authentication now is the default on new situations of PostgreSQL.

Copyright © 2021 IDG Communications, Inc.