Home

Postgres Pro Enterprise

Postgres Pro Enterprise is a commercial fork of the Postgres Pro Standard DBMS. It contains all the features of open-source PostgreSQL, Postgres Pro Standard enhancements as well as additional improvements and extensions for large-scale, high-performance database setups with strict reliability and latency constraints.

Advanced features of Postgres Pro Enterprise

Feature	Total cost of ownership	Performance
Reliability
Storage format modified to significantly mitigate data loss risks and promptly notify the administrator about disk subsystems errors.	Up to 15% less TCO	n/a
Several functions added to perform consistency checks for database and backups	Up to 10% less TCO	n/a
The multimaster cluster ensures effective processing of read-only queries thanks to load balancing.	Up to 25% less TCO	Several times higher performance for read-only operations
Performance and Scalability
Data compression at the database block level requires less disk storage space and ensures higher performance at the same time.	Up to 30% less TCO due to reduced storage hardware and maintenance costs	Up to 5x higher performance
In-core partitioning implementation is optimized for heavy workloads.	Up to 15% less TCO	Several times higher performance
The multimaster cluster ensures effective processing of read-U	Up to 25% less TCO	Performance of read operations grows according to the number of cluster nodes
64-bit transaction identifiers improve performance by reducing background activity and also fix the transaction ID wraparound issue.	Up to 15% less TCO	Up to 50% higher performance
Smarter temporary objects treatment is very advantageous for the applications that use them actively.	n/a	Up to 2x higher performance
Adaptive query optimization helps build better query execution plans thanks to machine learning technologies.	n/a	Up to 50% higher performance
The transferable tables engine enables distributed data processing setups and flexible data consolidation.	Up to 15% less TCO	n/a
Jsonb dictionary coder ensures the smaller size and higher processing speed for JSON data.	Up to 20% less TCO due to reduced storage hardware and maintenance costs	Up to 50% higher performance
Covering indexes enable complex operations with data relying only on the chosen index.	n/a	Up to 30% higher performance
Improved KNN (K-Nearest Neighbors) engine simplifies a number of search operations.	n/a	Several times higher performance
Accelerated full-text search ensures faster and more effective processing of text documents.	n/a	Up to 10x higher performance
The index creation engine is optimized for clusters to decrease the workload on servers and create indexes faster.	Up to 15% less TCO	Up to 30% higher performance
Security
Storing checksums in the data files and blocks plus database file checks to mitigate the data corruption risks.	Up to 15% less TCO	n/a
The SHA2 algorithm is used to ensure better protection for the password hashes.	n/a	n/a
Data compression hampers unauthorized access to the on-disk data.	Up to 30% less TCO due to reduced storage hardware and maintenance costs	Up to 5x higher performance
Session duration restrictions help protect connections from malicious usage.	n/a	n/a
Maintenance
Optimized partitioning simplifies work with the partitioned tables thanks to automatization.	Up to 15% less TCO	Up to 2x higher performance
The incremental backup feature ensures efficient backups of large databases.	Up to 50% less TCO thanks to more efficient backup system setup and maintenance	Up to 25% higher performance
A handy backup tool simplifies a number of operations for making and restoring backups.	Up to 15% less TCO	n/a
An advanced task scheduler helps automate database-related processes.	Up to 25% less TCO	n/a
Autonomous transactions provide a useful technique for logging of operations and errors on the server side.	Up to 15% less TCO	n/a
A transferable tables engine enables working with data from multiple databases.	Up to 15% less TCO	n/a
Support for query plan hints and ability to save and reuse of query plans, give a database administrator better control over query execution.	Up to 25% less TCO	Up to 30% higher performance
The lock-free file re-pack utility simplifies the DBA's work and reduces downtime.	Up to 25% less TCO	Up to 25% higher performance
Multimaster makes setup and maintenance of fault-tolerant configurations much easier and enables DBMS version upgrades during which the database remains available.	Up to 25% less TCO	Several times higher performance for read-only operations
The monitoring agent collects all important metrics related to the database usage.	Up to 15% less TCO	n/a
Query status monitoring tools help detect query execution anomalies.	Up to 15% less TCO	n/a
The lock monitoring feature informs DBAs about locks and helps them improve DBMS behavior.	Up to 20% less TCO	n/a
The WAL dump utility can help simplify backup and recovery operations.	Up to 15% less TCO	n/a

The supported platforms are:

Postgres Pro Enterprise License →

Postgres Pro Enterprise: Solution Benefits

Improved data compression

Data compression at the database block level to minimize the data footprint and increase performance. Save up to 20% on infrastructure costs for cloud database deployments.

Multimaster Postgres cluster

High-performance, scalable, fault-tolerant shared-nothing cluster (multimaster) with synchronous logical replication and single-digit seconds failover time.

Reliable incremental backup

Incremental backup with consistency checks for increased data protection and simplicity, even with terabytes of data.

Effective table partitioning

Partitioning for 10,000+ partitions for simpler management and faster processing of large volumes of data in the database.

Adaptive query planning

ML-based adaptive query planning for increased adaptability to particular information structures and data value distribution.

Advanced task scheduler

Advanced task scheduler for complex processing of data based on specific schedules or events.

In-memory data processing

In-memory data processing for faster processing of critical data.

Accelerated full-text search

Accelerated full-text search for faster and more effective scanning of text documents.

Cluster-optimized indexing

Index creation engine optimized for clusters to decrease the workload on servers.