Choosing a Postgres distribution v4

Suggest edits

EDB Postgres Distributed can be deployed with three different Postgres distributions: PostgreSQL, EDB Postgres Extended Server, or EDB Postgres Advanced Server. The availability of particular EDB Postgres Distributed features depends on which Postgres distribution is used. Therefore, it is essential to adopt the Postgres distribution best suited to your business needs. For example, if having the feature "Commit At Most Once (CAMO)" is mission critical to your use case, you should not adopt open source PostgreSQL because it does not have the core capabilities required to handle CAMO.

The following table lists features of EDB Postgres Distributed that are dependent on the Postgres distribution and version.

FeaturePostgreSQLEDB Postgres ExtendedEDB Postgres Advanced
Commit At Most Once (CAMO)NY14+
Group CommitNY14+
Eager ReplicationNY14+
Decoding WorkerN13+14+
Assessment ToolingNY14+
Lag TrackerNY14+
Lag ControlNY14+
Timestamp SnapshotsNY14+
Transaction Streaming14+13+14+
Missing Partition ConflictNY14+
No need for UPDATE Trigger on tables with TOASTNY14+
Automatically hold back FREEZENY14+