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|
|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|
|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|
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: 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.
Index creation engine optimized for clusters to decrease the workload on servers.