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

FeatureTotal cost of ownershipPerformance

Reliability

Storage format modified to significantly mitigate data loss risks and promptly notify the administrator about disk subsystems errors.Up to 15% less TCOn/a
Several functions added to perform consistency checks for database and backupsUp to 10% less TCOn/a
The multimaster cluster ensures effective processing of read-only queries thanks to load balancing.Up to 25% less TCOSeveral 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 costsUp to 5x higher performance
In-core partitioning implementation is optimized for heavy workloads.Up to 15% less TCOSeveral times higher performance
The multimaster cluster ensures effective processing of read-UUp to 25% less TCOPerformance 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 TCOUp to 50% higher performance
Smarter temporary objects treatment is very advantageous for the applications that use them actively.n/aUp to 2x higher performance
Adaptive query optimization helps build better query execution plans thanks to machine learning technologies.n/aUp to 50% higher performance
The transferable tables engine enables distributed data processing setups and flexible data consolidation.Up to 15% less TCOn/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/aUp to 30% higher performance
Improved KNN (K-Nearest Neighbors) engine simplifies a number of search operations.n/aSeveral times higher performance
Accelerated full-text search ensures faster and more effective processing of text documents.n/aUp 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 TCOUp 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 TCOn/a
The SHA2 algorithm is used to ensure better protection for the password hashes.n/an/a
Data compression hampers unauthorized access to the on-disk data.Up to 30% less TCO due to reduced storage hardware and maintenance costsUp to 5x higher performance
Session duration restrictions help protect connections from malicious usage.n/an/a

Maintenance

Optimized partitioning simplifies work with the partitioned tables thanks to automatization.

Up to 15% less TCOUp 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 maintenanceUp to 25% higher performance
A handy backup tool simplifies a number of operations for making and restoring backups.Up to 15% less TCOn/a
An advanced task scheduler helps automate database-related processes.Up to 25% less TCOn/a
Autonomous transactions provide a useful technique for logging of operations and errors on the server side.Up to 15% less TCOn/a
A transferable tables engine enables working with data from multiple databases.Up to 15% less TCOn/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 TCOUp to 30% higher performance
The lock-free file re-pack utility simplifies the DBA's work and reduces downtime.Up to 25% less TCOUp 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 TCOSeveral times higher performance for read-only operations
The monitoring agent collects all important metrics related to the database usage.Up to 15% less TCOn/a
Query status monitoring tools help detect query execution anomalies.Up to 15% less TCOn/a
The lock monitoring feature informs DBAs about locks and helps them improve DBMS behavior.Up to 20% less TCOn/a
The WAL dump utility can help simplify backup and recovery operations.Up to 15% less TCOn/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.