Comparison with Greenplum Features

SynxDB is 100% compatible with Greenplum, and provides all the Greenplum features you need.

In addition, SynxDB possesses some features that Greenplum currently lacks or does not support. More details are listed below.

General features

Note

  • In the following tables, ✅ means support, and ❌ means no support.

  • The feature comparison in the following tables is based on Greenplum 7 Beta.3.

Feature names

SynxDB

Greenplum

EXPLAIN (WAL) support

✅

❌

Multiranges

✅

❌

B-tree bottom-up index deletion

✅

❌

Covering indexes for GiST (INCLUDE)

✅

✅ (Upcoming)

The range_agg range type aggregation function

✅

❌

CREATE ACCESS METHOD

✅

✅ (Upcoming)

LZ4 compression for TOAST tables

✅

❌

JSONB subscripting

✅

❌

Configure the maximum WAL retention for replication slots

✅

❌

Verify backup integrity (pg_verifybackup)

✅

❌

Clients can require SCRAM channel binding

✅

❌

Vacuum “emergency mode”

✅

❌

Certificate authentication with postgres_fdw

✅

❌

UPSERT

✅

✅ (Upcoming)

COPY FROM WHERE

✅

❌

VACUUM / ANALYZE Skip Lock Table

✅

❌

HASH partitioned table

✅

❌

CTE (SEARCH and CYCLE)

✅

❌

Procedure OUT parameters

✅

❌

CHECK constraints for foreign tables

✅

❌

Timeout parameter for pg_terminate_backend

✅

❌

Auto failover for coordinator

✅

❌

Kubernetes deployment support

✅

❌