Postgres Pro Enterprise 13 Released
Written by Kay Ewbank   
Monday, 21 June 2021

Postgres Pro Enterprise has been updated and open sourced. The new release of the private fork of PostgreSQL is based on PostgreSQL 13.3.

Postgres Pro Enterprise consists of PostgreSQL with some additional patches applied and extensions added, including third-party patches that the PostgreSQL community intends to add to upcoming PostgreSQL versions. The company has also open sourced its multi-master cluster, making these capabilities available to the community.

postent

PostgreSQL 13 was released last year with improvements to its indexing and lookup system that benefit large databases, including space savings and performance gains for indexes, faster response times for queries that use aggregates or partitions, and better query planning when using enhanced statistics. The new release also added parallelized vacuuming and incremental sorting. 

The main improvements in Postgres Pro Enterprise 13 start with online upgrades for minor releases, so users can avoid having to restart their server or interrupting client connections when installing an upgrade. 

There's also an improved compressed file system based on the lz4 compression library, and a more transparent and manageable Write-Ahead Log (WAL).

Other improved features are support for data compression at the database block level to minimize the data footprint and increase performance; and Incremental backup with consistency checks for increased data protection and simplicity, even with terabytes of data.

There's a new built-in task scheduler for delayed, scheduled or asynchronous execution of offline jobs, and table partitioning can now be carried out for more than 10,000 partitions for simpler management and faster processing of large volumes of data in a single database.

One interesting addition is machine-learning based adaptive query planning, which the developers say provides increased adaptability to particular workload and data value distribution.

Postgres Pro Enterprise 13 is available now as a virtual machine image in the Microsoft Azure Marketplace.

postent

More Information

PostgresPro Website

Related Articles

Postgre SQL For Everybody - New On Coursera Plus

PostgreSQL Is DB-Engines DBMS of the Year For 2020

PostgreSQL Multi-Model Graph Extension Announced

PostgREST Turns PostGRE RESTful

PostgreSQL 12 Released

The Enduring Influence Of Postgres

PostgreSQL Improves Declarative Partitioning 

PostgreSQL Adds Parallel Query Support

 

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.

Banner


Google Gemini API Developer Competition
17/05/2024

Google is running a Gemini API Developer Competition with prizes including a 1981 custom electric DeLorean. Entrants will use the Gemini API to tackle real-world challenges, and the organizers su [ ... ]



Remembering Robert Dennard, Inventor of DRAM
19/05/2024

Robert Dennard, the IBM engineer who invented the key memory technology DRAM that we now rely on in our computers smartphones and tablets,  passed away on April 23rd, 2024, at age 91.


More News

raspberry pi books

 

Comments




or email your comment to: comments@i-programmer.info

Last Updated ( Monday, 21 June 2021 )