PGD compared v5.6
Warning: You are not reading the most recent version of this documentation.
Documentation improvements are made only to the latest version.
As per semantic versioning, PGD minor releases remain backward compatible and may include important bug fixes and enhancements.
We recommend upgrading the latest minor release as soon as possible.
If you want up-to-date information, read the latest PGD documentation.
Documentation improvements are made only to the latest version.
As per semantic versioning, PGD minor releases remain backward compatible and may include important bug fixes and enhancements.
We recommend upgrading the latest minor release as soon as possible.
If you want up-to-date information, read the latest PGD documentation.
The following table compares EDB Postgres Distributed with other replication solutions.
| PGD Standalone | PGD Managed | PSR + EFM | pglogical 2 | PG Builtin Logical Replication | |
|---|---|---|---|---|---|
| Version at last update (2024-11-15) | 5.6.1 | 5.6.1 | 4.10 | 2.4.5 | 17 |
| Deployment | |||||
| On Premise | Yes | Yes | Yes | Yes | Yes |
| Multi-cloud | Yes | Yes | Yes | Yes | Yes |
| Hybrid (on-prem + cloud) | Yes | Coming Soon | Yes | Yes | Yes |
| SLA | 99.999 | 99.995 | 99.99 | N/A | N/A |
| Performance | |||||
| Read Scalability | Yes | No | Yes - Physical standbys | Yes - More nodes | Yes - More nodes |
| Horizontal Scalability | No | No | No | No | No |
| Transaction Streaming | Yes | Yes | Yes | No | Yes |
| Parallel Apply (Vertical Scalability) | Yes | Yes | No | No | Partial - for large transactions only |
| Durability | |||||
| Asynchronous Replication | Yes | Yes | Yes | Yes | Yes |
| Optional RPO limit for asynchronous replication | Yes | Yes | No | No | No |
| Synchronous Replication | Yes | Yes | Yes | Yes | Yes |
| Consensus based replication | Yes | Yes | No | No | No |
| Per transaction durability setting | Yes | Yes | Yes | Yes | Yes |
| Consistenct | |||||
| Automatic conflict management | Yes | Yes | N/A | Yes | No |
| Conflict avoidance types | Yes | Yes | N/A | No | No |
| Conflict avoidance at commit (pessimistic conflict handling) | Yes | Yes | N/A | No | No |
| Builtin distributed sequence | Yes - snowflake (bigint) - galloc (int/bigint) | Yes - snowflake (bigint) - galloc (int/bigint) | N/A | No | No |
| Data Distibution | |||||
| Data residency/selective replication | Yes | Yes | No | Yes | Yes |
| Cluster level Active-Active (writers in different regions) | Yes | Yes | No | Manual setup | No |
| Regional Active-Active (multiple writers within region) | Yes - not recommended unless specific setup | No | No | Manual setup | No |
| Automatic partitioning | Yes | Yes | Yes with EPAS | No | No |
| Offload cold data to cheaper storage | Yes | Yes | No | No | No |
| Maintenance | |||||
| Near-zero downtime major version upgrades by adding nodes | Yes | Yes | Yes - using logical replication | Yes | Yes |
| Near-zero downtime inplace major version upgrades | Yes | Yes | No | No | No |
| Rolling schema upgrades/green-blue (with application assistance) | Yes | Yes | No | No | No |
| Rolling maintenance operations | Yes | Yes | No | Yes | Yes |
| Connection Mgmt | |||||
| Automatic failover | Yes | Yes | Yes | N/A | N/A |
| Automatic connection failover for switchover | Yes | Yes | Yes | N/A | N/A |
| Cluster level connection routing | Yes | Yes | Yes | N/A | N/A |
| Region level connection routing | Yes | Yes | No | N/A | N/A |
| pgbouncer support | Yes | No | Yes | N/A | N/A |
| DDL Support | |||||
| General DDL replication | Yes | Yes | Yes | Manual | No |
| Granular (per-object) DDL locking | Yes | Yes | Yes | No | No |
| Create and drop objects | Yes | Yes | Yes | Manual | No |
| Add columns to table | Yes | Yes | Yes | Unsafe/manual | No |
| Change column type | Yes - rewrite requires permit_unsafe_commands | Yes - rewrite requires permit_unsafe_commands | Yes | Unsafe/manual | No |
| CREATE TABLE AS | Yes - with restrictions | Yes - with restrictions | Yes | Unsafe/manual | No |
| PG Compatibility | |||||
| Latest supported version | 17 | 17 | 17 | 17 | 17 |
| Works on standard PG | Yes | No | Yes | Yes | Yes |
| Supports TDE | Yes with EPAS/PGE | Yes with EPAS/PGE | Yes with EPAS/PGE | No | Yes with EPAS/PGE |
| Supports custom types (i.e. Postgis) | Yes | Yes | Yes | Yes | Yes |
| Supports extensions | Many | Many | All | Many | Many |
| CDC failover support | No | No | Yes | N/A | N/A |
| Large Object support | No | No | Yes | No | No |
| Multiple DB support | No | No | Yes | N/A | N/A |
| Management | |||||
| CLI | Yes | Yes | Yes | No | No |
| GUI | PEM | Yes | PEM | No | No |
| Monitoring options | - SQL - CLI - PEM | - SQL - CLI - UPM | - SQL - CLI - PEM | SQL | SQL |
| Licensing | |||||
| Source available | No | No | No | Yes | Yes |
| Open source | No | No | No | Yes | Yes |