Feature Comparison

Postgres Pro Enterprise vs. Postgres Pro Standard

Key features

Enhancements developed by Postgres Professional team

Postgres Pro

PostgreSQL fork created to meet the needs of large enterprises

Postgres Pro

PostgreSQL fork with early access to the newest PostgreSQL features

Failover configuration: a primary server plus standby servers
Reading data from a standby server
Transaction DDL
Extendable architecture (new data types, indexes, programming languages can be added dynamically)
Full-text search
Support for semi-structured data, SQL/JSON
Failover master-master configuration (multimaster)
Data compression
64-bit transaction ID (xid)
Built-in connection pooler
Block-level incremental backup with data consistency checks
Autonomous transactions
Built-in task scheduler
ML-based query optimization
Efficient partitioning for 10,000+ partitions
Detection of the most resource-consuming operations based on historical workloads analysis
Corrupted WAL data recovery feature
Audit of various events related to security
Extended authentication policies
Automatic page repair while streaming replication in case of data corruption (non-corrupted pages are requested from the standby server)
Relaxation of synchronous replication restrictions to let the primary server continue to work if one of the standby servers is temporarily unavailable
Improved lock checking mechanism that does not negatively impact performance
Increased scheduling speed and efficiency for various types of queries
Reduced memory consumption when processing complex queries to multiple tables
Statistics updates in target tables after DML operations
Data statistics to be saved during backup and restore
Statistics on SQL query execution and wait events to be collected
Managing query plans with special pointers for the scheduler
Checking query execution status in the served process
Full list of features Request free demo ↗︎ Download free trial ↓