PGD compared#
次の表では、EDB Postgres Distributedと他のレプリケーションソリューションを比較しています。
PGD Standalone |
PGD Managed |
PSR + EFM |
pglogical 2 |
PG Builtin Logical Replication |
|
|---|---|---|---|---|---|
<small>Version at last update (2025-06-19)</small> |
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 |
Consistency |
|||||
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 Distribution |
|||||
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 |
||||
Rolling maintenance operations |
Yes |
Yes |
No |
Yes |