Postgres Pro Enterprise is a commercial fork of the Postgres Pro Standard DBMS that contains all the features of the open source version with the number of additional improvements and extensions developed for large databases, high performance, and strong reliability requirements.
Extra features of Postgres Pro Enterprise (compared with Postgres Pro Standard)
| Feature | Total cost of ownership | Performance |
|---|---|---|
| Reliability | ||
| Storage format modified in order to significantly reduce the risks of data loss and promptly notify the administrator in case of disk subsystems errors. | Saves up to 15% | Not affected |
| Added several functions to perform database and backups consistency checks | Saves up to 10% | Not affected |
| Multimaster allows to process read-only queries in an effective way by the distribution of a workload across many nodes. | Saves up to 25% | Multiple increase for read-only operations |
| Performance and Scalability | ||
| Data compession technology allows to substantially reduce the disk storage requirements and to increase performance at the same time. | Saves up to 30% on the storage hardware and maintenance | Increase by up to 5 times |
| Optimized in-core partitioning implementation allows to deal with the big data load efficiently | Saves up to 15% | Multiple increase |
| Multimaster allows to process read-only queries in an effective way by the distribution of a workload across many nodes. | 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 that is very advantageous for the applications that use them actively. | Not affected | Increase by up to 2 times |
| Adaptive Query Optimization allows to build the better query execution plans by using the machine learning technologies. | Not affected | Increase by up to 50% |
| Transferable tables engine allows to build distributed data processing setup and to consolidate all the data needed in a flexible way. | Saves up to 15% | Not affected |
| Jsonb compression reduces the JSON data size and increases the processing speed | Saves up to 20% on the storage hardware and maintenance | Increase by up to 50% |
| Covering indexes allows to perform the complex operations on data, by using only an index | Not affected | Increase by up to 30% |
| Improved KNN (K-Nearest Neighbors) engine simplifies a number of search operations | Not affected | Multiple increase |
| Accelerated full-text search allows to process text documents in a more effective way | Not affected | Increase by up to 10 times |
| Index creation engine optimized for clusters so servers workload is decreased and indexes are created faster. | Saves up to 15% | Increase by up to 30% |
| Security | ||
| Storing checksums in the data files and blocks and also the database files checks reduce the risks of data corruption | Saves up to 15% | Not affected |
| SHA2 algorithm usage provides better protection for the password hashes | Not affected | Not affected |
| Data compression complicates unauthorized reading of the on-disk data | Saves up to 30% on the storage hardware and maintenance | Increase by up to 5 times |
| Session duration restrictions help to protect connections from malicious usage | Not affected | Not affected |
| Maintenance | ||
| Optimized partitioning provides automated approach to partitioning and thus significantly simplifies work with the partitioned tables | Saves up to 15% | Increase by up to 2 times |
| Incremental backup allows to make backups of large database in an effective way | Saves up to 50% on the backup system setup and maintenance | Increase by up to 25% |
| Handy backup tool simplifies the various operations involved in making and restoring backups | Saves up to 15% | Not affected |
| Embedded task scheduler helps to automate database-related processes. | Saves up to 25% | Not affected |
| Autonomous transactions provide the useful technique for logging of operations and errors on the server side. | Saves up to 15% | Not affected |
| Transferable tables engine allows to access data from the multiple databases | Saves up to 15% | Not affected |
| Support for query plan hints and features to save and reuse query plans give the better control on the query execution to a database administrator | Saves up to 25% | Increase by up to 30% |
| File repack utility that avoids locking simplifies the database administrator work and reduces downtime | Saves up to 25% | Increase by up to 25% |
| Multimaster makes the setup and the maintenance of the fault-tolerant configurations much easier and allows to upgrade DBMS version while preserving the availability | Saves up to 25% | Multiple increase for read-only operations |
| Monitoring agent allows to collect all the important information 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 |
| Lock monitoring feature informs database administrator about the locks and helps to improve the DBMS behaviour | Saves up to 20% | Not affected |
| WAL dump utility can be useful to simplify backup and recovery operations | Saves up to 15% | Not affected |
The supported platforms are:
- AIX*,
- Alt Linux SPT 7,
- CentOS 7,
- Debian 8, 9
- Microsoft® Windows® 2012,
- RHEL 7,
- Rosa EL 6,
- Rosa SX Cobalt 6,
- SLES11 sp4,
- Ubuntu 16.04.