Postgres Professional announced the availability of Postgres Pro Enterprise 13. Based on PostgreSQL 13.3, Postgres Pro Enterprise 13 includes all the new features introduced in PostgreSQL 13, as well as key Postgres Professional innovations, such as hot minor upgrades, storage-level compression and 64-bit transaction identifiers. The company has also announced it has open sourced its innovative multi-master cluster, making these capabilities available to the community.

Postgres Pro Enterprise is a private, fully supported PostgreSQL fork targeted for very large production systems of major financial institutions, government agencies and top online retailers. It includes functionality designed to meet the strictest requirements for security, scalability and high availability. Enhanced features include:

• Data compression at the database block level to minimize the data footprint and increase performance.
• Incremental backup with consistency checks for increased data protection and simplicity, even with terabytes of data.
• Advanced built-in task scheduler for delayed, scheduled or asynchronous execution of offline jobs.
• ML-based adaptive query planning for increased adaptability to particular workload and data value distribution.
• Effective table partitioning for 10000+ partitions for simpler management and faster processing of large volumes of data in a single database.
  

"We are very excited to bring Postgres Pro Enterprise 13 to market because it enables enterprises to update their production systems with the latest PostgreSQL features and fixes while still taking advantage of all the advanced features that Postgres Pro Enterprise provides," said Oleg Bartunov, Postgres Professional Founder and CEO. "Postgres Pro Enterprise 13 will enable more companies in more industries to take advantage of all the great benefits of PostgreSQL. Further, by open sourcing the multi-master functionality, we are opening this key capability to a wider audience of developers and users."

Top new features of Postgres Pro Enterprise 13:

• Hot upgrades for minor releases - Online upgrade for minor version releases has been implemented, allowing an upgrade to the next minor version without a server restart or interrupting the existing client connections. This is currently supported on Linux platforms.
• More transparent and manageable Write-Ahead Log (WAL) - A new WAL view (pgpro_stat_wal_activity) shows the size of WAL generated by each server process.
• Improved compressed file system - Support for the lz4 compression library has been added to the compressed file system.
  

Improved multi-master contributed to the community

Postgress Professional has open sourced its improved multi-master extension. It now relies on the Paxos consensus algorithm and two-phase commit protocol with generations to determine a transaction outcome. This allows developers to use various cluster configurations.

More Advanced and More Current, but Drop-in Compatible with PostgreSQL 13.3

Postgres Pro Enterprise 13, which is almost fully drop-in compatible with PostgreSQL 13.3, also includes new bug fixes and performance enhancements that are typically not incorporated into PostgreSQL until the next major release. 

For a complete list of enhancements in Postgres Pro Enterprise 13, visit https://postgrespro.com/docs/enterprise/13/intro-pgpro-vs-pg.

Availability

Postgres Pro Enterprise 13, along with previous versions, is available now in the Microsoft Azure Marketplace as a virtual machine (VM) offering.