Postgres Pro Enterprise

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)

FeatureTotal cost of ownershipPerformance
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 checksSaves 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 maintenanceIncrease by up to 5 times
Optimized in-core partitioning implementation allows to deal with the big data load efficientlySaves 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 affectedIncrease by up to 2 times
Adaptive Query Optimization allows to build the better query execution plans by using the machine learning technologies.Not affectedIncrease 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 speedSaves up to 20% on the storage hardware and maintenanceIncrease by up to 50%
Covering indexes allows to perform the complex operations on data, by using only an indexNot affectedIncrease by up to 30%
Improved KNN (K-Nearest Neighbors) engine simplifies a number of search operationsNot affectedMultiple increase
Accelerated full-text search allows to process text documents in a more effective wayNot affectedIncrease 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 corruptionSaves up to 15%Not affected
SHA2 algorithm usage provides better protection for the password hashesNot affectedNot affected
Data compression complicates unauthorized reading of the on-disk dataSaves up to 30% on the storage hardware and maintenanceIncrease by up to 5 times
Session duration restrictions help to protect connections from malicious usageNot affectedNot affected
Maintenance
Optimized partitioning provides automated approach to partitioning and thus significantly simplifies work with the partitioned tablesSaves up to 15%Increase by up to 2 times
Incremental backup allows to make backups of large database in an effective waySaves up to 50% on the backup system setup and maintenanceIncrease by up to 25%
Handy backup tool simplifies the various operations involved in making and restoring backupsSaves 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 databasesSaves 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 administratorSaves up to 25%Increase by up to 30%
File repack utility that avoids locking simplifies the database administrator work and reduces downtimeSaves 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 availabilitySaves up to 25%Multiple increase for read-only operations
Monitoring agent allows to collect all the important information related to the database usageSaves up to 15%Not affected
Query status monitoring tools help detect query execution anomaliesSaves up to 15%Not affected
Lock monitoring feature informs database administrator about the locks and helps to improve the DBMS behaviourSaves up to 20%Not affected
WAL dump utility can be useful to simplify backup and recovery operationsSaves 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.