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.
Extra features of Postgres Pro Enterprise (compared with Postgres Pro Standard)
| Feature | The total cost of ownership | Performance |
|---|---|---|
| Reliability | ||
| Storage format modified to significantly mitigate data loss risks and promptly notify the administrator about disk subsystems errors. | Saves up to 15% | Not affected |
| Several functions added to perform consistency checks for database and backups | Saves up to 10% | Not affected |
| The multi-master cluster ensures effective processing of read-only queries thanks to load balancing. | Saves up to 25% | Multiple increases for read-only operations |
| Performance and Scalability | ||
| Data compression at the block level requires less disk storage space and ensures higher performance at the same time. | Saves up to 30% on the storage hardware and maintenance | Increase by up to 5 times |
| In-core partitioning implementation is optimized for heavy workloads. | Saves up to 15% | Multiple increases |
| The multi-master cluster ensures effective processing of read-only queries thanks to load balancing. | Saves up to 25% | Increase by multiplying by the number of nodes |
| 64-bit transaction identifiers improve performance by reducing background activity and also fix the transaction ID wraparound issue. | Saves up to 15% | Increase by up to 50% |
| Smarter temporary objects treatment is very advantageous for the applications that use them actively. | Not affected | Increase by up to 2 times |
| Adaptive Query Optimization helps build better query execution plans thanks to machine learning technologies. | Not affected | Increase by up to 50% |
| The transferable tables engine enables distributed data processing setups and flexible data consolidation. | Saves up to 15% | Not affected |
| Jsonb dictionary coder ensures the smaller size and higher processing speed for JSON data. | Saves up to 20% on the storage hardware and maintenance | Increase by up to 50% |
| Covering indexes enable complex operations with data relying only on the chosen index. | Not affected | Increase by up to 30% |
| Improved KNN (K-Nearest Neighbors) engine simplifies a number of search operations. | Not affected | Multiple increases |
| Accelerated full-text search ensures faster and more effective processing of text documents. | Not affected | Increase by up to 10 times |
| The index creation engine is optimized for clusters to decrease the workload on servers and create indexes faster. | Saves up to 15% | Increase by up to 30% |
| Security | ||
| Storing checksums in the data files and blocks plus database file checks to mitigate the data corruption risks. | Saves up to 15% | Not affected |
| The SHA2 algorithm is used to ensure better protection for the password hashes. | Not affected | Not affected |
| Data compression hampers unauthorized access to the on-disk data. | Saves up to 30% on the storage hardware and maintenance | Increase by up to 5 times |
| Session duration restrictions help protect connections from malicious usage. | Not affected | Not affected |
| Maintenance | ||
Optimized partitioning simplifies work with the partitioned tables thanks to automatization | Saves up to 15% | Increase by up to 2 times |
| The incremental backup feature ensures efficient backups of large databases. | Saves up to 50% on the backup system setup and maintenance | Increase by up to 25% |
| A handy backup tool simplifies a number of operations for making and restoring backups. | Saves up to 15% | Not affected |
| An advanced task scheduler helps automate database-related processes. | Saves up to 25% | Not affected |
| Autonomous transactions provide a useful technique for logging of operations and errors on the server side. | Saves up to 15% | Not affected |
| A transferable tables engine enables working with data from multiple databases. | Saves up to 15% | Not affected |
| Support for query plan hints and features, enabling saving and re-using of the query plans, give a database administrator better control over query execution. | Saves up to 25% | Increase by up to 30% |
| The lock-free file re-pack utility simplifies the DBA's work and reduces downtime. | Saves up to 25% | Increase by up to 25% |
| Multi-master makes setup and maintenance of fault-tolerant configurations much easier and enables DBMS version upgrades during which the database remains available. | Saves up to 25% | Multiple increases for read-only operations |
| The monitoring agent collects all important metrics related to the database usage. | Saves up to 15% | Not affected |
| Query status monitoring tools help detect query execution anomalies. | Saves up to 15% | Not affected |
| The lock monitoring feature informs DBAs about locks and helps them improve DBMS behavior. | Saves up to 20% | Not affected |
| The WAL dump utility can help simplify backup and recovery operations. | Saves up to 15% | Not affected |
- AlterOS 7
- Lat Server 9 / 8
- Alt Linux SPT 8.2 / 8 / 7
- Astra Linux Special Edition (Leningrad) 8.1
- Astra Linux Common Edition (Orel) 2.12
- Astra Linux Special Edition (Smolensk) 1.7 / 1.6 / 1.5
- CentOS 8 / 7
- Debian 11 / 10 / 9 / 8
- Oracle Linux 8 / 7
- OSnova 2.0
- RED OS 7.3 / 7
- Red Hat Enterprise Linux 8 / 7
- ROSA Enterprise Linux Server 7
- Rosa SX 7
- SUSE Linux Enterprise Server 15 / 12
- Ubuntu 20.04 / 18.04
- Windows / Windows Server
Postgres Pro Enterprise License