Postgres Professional has announced the availability of Postgres Pro Enterprise 13.
The company has also open sourced its multi-master cluster, making these capabilities available to the community.
Based on PostgreSQL 13.3, Postgres Pro Enterprise 13 includes the new features introduced in PostgreSQL 13, as well as key Postgres Professional additions, such as hot minor upgrades, storage-level compression, and 64-bit transaction identifiers.
Postgres Pro Enterprise is a private PostgreSQL fork targeted at very large production systems of major financial institutions, industrial giants, and top online retailers. According to the company, it includes functionality designed to meet the strictest requirements for security, scalability and high availability.
The top new features of Postgres Pro Enterprise 13 are:
- 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.
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 more than 10,000 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.”
Postgres Pro Enterprise 13, which the company says, 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.
Postgres Pro Enterprise 13, along with previous versions, is available now in the Microsoft Azure Marketplace as a virtual machine (VM) offering.