PGD compared
============

The following table compares EDB Postgres Distributed with other
replication solutions.

.. csv-table::
  :header: "",PGD Standalone,PGD Managed,PSR + EFM,pglogical 2,PG Builtin Logical Replication
  :widths: 10,7,7,7,7,7
  :align: left
  :class: longtable

  <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
  **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