PGD compared v5.6
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 |