PGD compared#
次の表では、EDB Postgres Distributedと他のレプリケーションソリューションを比較しています。
PGD Standalone |
PGD Managed |
PSR + EFM |
pglogical 2 |
PG Builtin Logical Replication |
|
|---|---|---|---|---|---|
Version at last update (2025-06-19) |
6.x |
6.x |
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 |
SQL |
Licensing |
|||||
Source available |
No |
No |
No |
Yes |
Yes |
Open source |
No |
No |
No |
Yes |
Yes |