Feature Comparison
Postgres Pro Enterprise vs Postgres Pro Standard vs PostgreSQL
Key featuresEnhancements developed by Postgres Professional team |
Postgres Pro
|
Postgres Pro
|
PostgreSQL
An open-source DBMS developed by the international community with significant contributions from Postgres Pro developers |
security |
|---|---|---|---|
| TDE (Transparent Data Encryption) | |||
| Data Masking | |||
| «Administrator without Data Access» role | |||
| Secure wiping of allocated RAM and disk space | |||
| pg_proaudit extension | |||
| pg_integrity_check utility | |||
| User Profiles | MANAGEABILITY | ||
| Postgres Pro Enterprise Manager | |||
| Online table relocation | RELIABILITY AND SCALABILITY | ||
| Built-in BiHA high-availability cluster | |||
| Incremental block-level backup | |||
| PG_Probackup (Enterprise edition) | |||
| Multimaster | PERFORMANCE | ||
| 64-bit transaction ID counter | |||
| Data compression (CFS) | |||
| Integration with the CITUS extension | |||
| Intelligent adaptive query optimization system (AQO 2.0 + Replan) | |||
| sr_plan | |||
| Autonomous transactions | |||
| Interval partitioning | |||
| Extended SQL/JSON support | |||
| Mamonsu — monitoring agent | |||
| Detection of resource-intensive operations (pgpro_pwr) | |||
| B-tree KNN: nearest-neighbor index search | |||
| Efficient partitioning | |||
| Combining full-text search with relevance indexing (RUM) | |||
| Performance monitoring and wait control during query execution (real-time monitoring and pg_query_state) | |||
| Login event triggers | |||
| Resource prioritization | |||
| Automatic page repair from replica | |||
| WAL repair from memory buffers | |||
| Changing configuration of other sessions | |||
| Deferred write of temporary tables to disk | |||
| PG_WAIT_SAMPLING | |||
| Automatic query preparation mode | EASING MIGRATION FROM ORACLE | ||
| Support for «Oracle-style» packages | |||
| ora2pgpro utility for fast conversion of application code | |||
| Postgres Pro Superfile technology (removes limitations on handling large data sets) | |||
| Support for external files (BFile) | |||
| PL/SQL collections | COMPATIBILITY | ||
| 250+ popular application systems | |||
| 35+ platforms | |||
| Full list of features | Request a Demo | Start a free trial |