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.

Extra features of Postgres Pro Enterprise (compared with Postgres Pro Standard)

FeatureThe total cost of ownershipPerformance
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 backupsSaves 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 maintenanceIncrease 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 affectedIncrease by up to 2 times
Adaptive Query Optimization helps build better query execution plans thanks to machine learning technologies.Not affectedIncrease 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 maintenanceIncrease by up to 50%
Covering indexes enable complex operations with data relying only on the chosen index.Not affectedIncrease by up to 30%
Improved KNN (K-Nearest Neighbors) engine simplifies a number of search operations.Not affectedMultiple increases
Accelerated full-text search ensures faster and more effective processing of text documents.Not affectedIncrease 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 affectedNot affected
Data compression hampers unauthorized access to the on-disk data.Saves up to 30% on the storage hardware and maintenanceIncrease by up to 5 times
Session duration restrictions help protect connections from malicious usage.Not affectedNot 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 maintenanceIncrease 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

 

 

The supported platforms are:

  • 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.6 / 1.5
  • CentOS 8 / 7
  • Debian 10 / 9 / 8
  • Oracle Linux 8 / 7
  • OSnova 2.0
  • RED OS 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