Comparison with Greenplum

SynxDB Elastic is highly compatible with Greenplum, and provides all the Greenplum features you need.

In addition, SynxDB Elastic 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 Elastic

Greenplum

EXPLAIN (WAL) support

✅

❌

Multiranges

✅

❌

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

✅

❌