whichdb
vs

Amazon Redshift vs Apache Cloudberry

Amazon Redshift: AWS's MPP columnar data warehouse, available as provisioned RA3 clusters or Serverless. Apache Cloudberry: Open-source MPP warehouse forked from Greenplum and rebased on a newer PostgreSQL kernel.

key differences

  • Amazon Redshift is primarily a columnar / OLAP database; Apache Cloudberry is relational.
  • Licensing: Amazon Redshift is proprietary (Proprietary); Apache Cloudberry is open source (permissive) (Apache License 2.0).
  • Amazon Redshift is built for larger datasets (Multi-PB) than Apache Cloudberry (≤ 1 PB).
  • Only Amazon Redshift has encryption at rest, online schema changes, streaming ingest.
  • Only Apache Cloudberry has secondary indexes, full-text search.
  • Amazon Redshift has a serverless option; Apache Cloudberry does not.

choose amazon-redshift for

  • +Enterprise data warehouse on AWS
  • +BI dashboards over curated marts
  • +Lakehouse queries over S3 with Spectrum
  • +Near-real-time analytics on Aurora data via zero-ETL

best at · Warehouse, OLAP, Lakehouse

choose apache-cloudberry for

  • +Migrating off closed-source Greenplum
  • +On-prem Postgres-compatible MPP warehouse
  • +Open-source alternative to commercial MPP appliances

best at · Warehouse, OLAP, Lakehouse

Amazon RedshiftAWS's MPP columnar data warehouse, available as provisioned RA3 clusters or Serverless.
Apache CloudberryOpen-source MPP warehouse forked from Greenplum and rebased on a newer PostgreSQL kernel.
overview
Primary model
Columnar / OLAP
Relational
Also supports
Relational, Document, Spatial
Columnar / OLAP, Spatial, Document
Type
Managed service
Database engine
Status
Active
Active
Developer
Amazon Web Services
Apache Software Foundation (Incubator)
First release
2012
2023
Latest version
–
2.1.0-incubating (Apr 15, 2026)
License
ProprietaryProprietary
Open source (permissive)Apache License 2.0
Free tier
—
✓
popularity
WhichDB Score
55.8
6.8
Rank
#21
#350
GitHub stars
–
1.4K
Stack Overflow questions
8.8K
–
scale & guarantees
Comfortable data size
Massive (Multi-PB)
Large (≤ 1 PB)
Horizontal scaling
Native
Native
Multi-region
Read replicas
None
ACID
Full
Full
Consistency
Strong
Strong
Schema
Strict
Strict
Architecture
Distributed, Shared storage, Serverless
Distributed, Client server
deployment
Self-hosted
—
✓
Vendor-managed cloud
✓
—
Serverless
✓
—
Embedded
—
—
Edge
—
—
Clouds
AWS
–
capabilities
Transactions
✓
✓
Joins
✓
✓
Secondary indexes
—
✓
Full-text search
—
✓
Vector search
—
—
Geospatial
✓
✓
JSON
✓
✓
Change data capture
—
—
Triggers
—
—
Stored procedures
✓
✓
Materialized views
✓
✓
TTL / expiry
—
—
Pub/Sub
—
—
Columnar storage
✓
✓
In-memory
—
—
Durable persistence
✓
✓
Compression
✓
✓
Encryption at rest
✓
—
Role-based access
✓
✓
Time travel
—
—
Branching
—
—
Online schema changes
✓
—
Streaming ingest
✓
—
Offline sync
—
—
Runs in WebAssembly
—
—
interfaces
Query languages
SQL (PostgreSQL dialect), PL/pgSQL
SQL, PL/pgSQL, PL/Python
Client languages
Python, Java, JavaScript, Go, .NET, C
C, Java, Python, Go, JavaScript
Best for
Warehouse, OLAP, Lakehouse
Warehouse, OLAP, Lakehouse
Add more to this comparisonNot sure either fits? Try smart match

Amazon Redshift vs Apache Cloudberry: FAQ

What is the difference between Amazon Redshift and Apache Cloudberry?

Amazon Redshift: AWS's MPP columnar data warehouse, available as provisioned RA3 clusters or Serverless. Apache Cloudberry: Open-source MPP warehouse forked from Greenplum and rebased on a newer PostgreSQL kernel. Amazon Redshift is primarily a columnar / OLAP database; Apache Cloudberry is relational. Licensing: Amazon Redshift is proprietary (Proprietary); Apache Cloudberry is open source (permissive) (Apache License 2.0). Amazon Redshift is built for larger datasets (Multi-PB) than Apache Cloudberry (≤ 1 PB).

When should I choose Amazon Redshift over Apache Cloudberry?

Choose Amazon Redshift for enterprise data warehouse on AWS, BI dashboards over curated marts and lakehouse queries over S3 with Spectrum. Choose Apache Cloudberry for migrating off closed-source Greenplum, on-prem Postgres-compatible MPP warehouse and open-source alternative to commercial MPP appliances.

Is Amazon Redshift or Apache Cloudberry more popular?

Amazon Redshift ranks #21 on the WhichDB Score (55.8/100) and Apache Cloudberry ranks #350 (6.8/100). Popularity is not fit: check the requirements that matter for your project.

Are Amazon Redshift and Apache Cloudberry open source?

No. Amazon Redshift is proprietary, closed-source software. Yes. Apache Cloudberry is open source. License: Apache License 2.0.