Feature Comparison
Postgres Pro Enterprise vs. Postgres Pro Standard
Key featuresEnhancements developed by Postgres Professional team |
Postgres Pro
|
Postgres Pro
|
|---|---|---|
| Failover configuration: a primary server plus standby servers | ||
| Reading data from a standby server | ||
| Transaction DDL | ||
| PITR | ||
| 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 ↓ |