Comparing replication solutions#
レプリケーションソリューションは、マルチリージョンの展開、競合管理、スキーマの変更、およびメジャーバージョンのアップグレードを処理する方法が大きく異なります。この比較を使用して、これらのディメンションの他のオプションと比較してPGDを評価します。
最終更新日2026-04-14
Product |
Version |
|---|---|
PGD Standalone |
Version 6.4 |
PGD HM-managed |
Version 6.4 |
PSR + EFM |
5.3 |
展開#
Product |
On premise |
Cloud |
Multi-cloud |
Hybrid (on-prem + cloud) |
SLA |
Native Kubernetes Operator |
|---|---|---|---|---|---|---|
PGD Standalone |
✓ |
✓ |
✓ |
✓ |
99.999 |
✓ (PGD for Kubernetes (GA Q1 2025), based on CloudNativePG) |
PGD HM-managed |
✓ |
✓ |
✓ |
✗ |
99.995 |
✓ |
PSR + EFM |
✓ |
✓ |
✓ |
✓ |
99.99 |
Partial (CloudNativePG, no native EFM integration) |
パフォーマンス#
Product |
Read scalability |
Horizontal scalability |
Transaction streaming |
Parallel apply (vertical scalability) |
Logical Change Record (LCR) sharing |
|---|---|---|---|---|---|
PGD Standalone |
✓ (subscriber only nodes) |
✗ |
✓ |
✓ |
✓ (decodes WAL once, shares to all subscribers) |
PGD HM-managed |
✗ |
✗ |
✓ |
✓ |
✓ |
PSR + EFM |
✓ (physical standbys) |
✗ |
✓ |
✗ |
✗ (decodes per subscriber) |
耐久性#
Product |
Asynchronous replication |
Optional RPO limit for asynchronous replication |
Synchronous replication |
Consensus based replication |
Per transaction durability setting |
|---|---|---|---|---|---|
PGD Standalone |
✓ |
✓ |
✓ |
✓ |
✓ |
PGD HM-managed |
✓ |
✓ |
✓ |
✓ |
✓ |
PSR + EFM |
✓ |
✗ |
✓ |
✗ |
✓ |
一貫性#
Product |
Automatic conflict management |
Conflict avoidance types |
Conflict avoidance at commit (pessimistic conflict handling) |
Builtin distributed sequence |
CRDT (Conflict-Free Replicated Data Types) |
|---|---|---|---|---|---|
PGD Standalone |
✓ |
✓ |
✓ |
✓ (snowflake (bigint), galloc (int/bigint)) |
✓ (multiple nodes update same row simultaneously without global locking) |
PGD HM-managed |
✓ |
✓ |
✓ |
✓ (snowflake (bigint), galloc (int/bigint)) |
✓ |
PSR + EFM |
N/A |
N/A |
N/A |
N/A |
✗ |
データ分散#
Product |
Data residency/selective replication |
Cluster level Active-Active (writers in different regions) |
Regional Active-Active (multiple writers within region) |
Automatic partitioning |
Offload cold data to cheaper storage |
|---|---|---|---|---|---|
PGD Standalone |
✓ |
✓ |
✓ (not recommended unless specific setup) |
✓ |
✓ |
PGD HM-managed |
✓ |
✓ |
✗ |
✓ |
✓ |
PSR + EFM |
✗ |
✗ |
✗ |
✓ with EPAS |
✗ |
メンテナンス#
Product |
Near-zero downtime major version upgrades by adding nodes |
Near-zero downtime inplace major version upgrades |
Rolling schema upgrades/green-blue (with application assistance) |
Rolling maintenance operations |
|---|---|---|---|---|
PGD Standalone |
✓ |
✓ |
✓ |
✓ |
PGD HM-managed |
✓ |
✓ |
✓ |
✓ |
PSR + EFM |
✓ (using logical replication) |
✗ |
✗ |
✗ |
接続管理#
Product |
Automatic failover |
Automatic connection failover for switchover |
Cluster level connection routing |
Region level connection routing |
pgbouncer support |
Built-in connection manager (no external consensus/proxy required) |
|---|---|---|---|---|---|---|
PGD Standalone |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ (PGD 6.0+, eliminates HARP + etcd dependency) |
PGD HM-managed |
✓ |
✓ |
✓ |
✓ |
✗ |
✓ |
PSR + EFM |
✓ |
✓ |
✓ |
✗ |
✓ |
✗ (requires pgbouncer / HAProxy) |
DDLサポート#
Postgresの互換性#
Product |
Latest supported version |
Works on standard PG |
Supports TDE |
Supports custom types (i.e. PostGIS) |
Supports extensions |
CDC failover support |
Large Object support |
Multiple DB support |
|---|---|---|---|---|---|---|---|---|
PGD Standalone |
18 |
✓ |
✓ with EPAS/PGE |
✓ |
Many |
✓ (PGD 5.7+) |
✗ |
✗ |
PGD HM-managed |
18 |
✗ |
✓ with EPAS/PGE |
✓ |
Many |
✓ (PGD 5.7+) |
✗ |
✗ |
PSR + EFM |
17 |
✓ |
✓ with EPAS/PGE |
✓ |
All |
✓ |
✓ |
✓ |
管理#
Product |
CLI |
UI |
Monitoring options |
|---|---|---|---|
PGD Standalone |
✓ |
✓ (PEM) |
Hybrid Manager, SQL, CLI, PEM |
PGD HM-managed |
✓ |
✓ |
Hybrid Manager, SQL, CLI, edbctl |
PSR + EFM |
✓ |
✓ (PEM) |
Hybrid Manager, SQL, CLI, PEM |
ライセンス#
Product |
Source available |
Open source |
|---|---|---|
PGD Standalone |
✗ |
✗ |
PGD HM-managed |
✗ |
✗ |
PSR + EFM |
✗ |
✗ |