# Apache Cloudberry

> Open-source MPP warehouse continuing the Greenplum lineage

Apache Cloudberry is an open-source massively parallel processing data warehouse built on a PostgreSQL 14 kernel, created by original Greenplum developers after Greenplum itself was closed-sourced.

Website: https://cloudberry.apache.org

## Use it when

- You want an MPP warehouse you can run yourself, with no vendor contract, under open Apache governance.
- You are on Greenplum and Broadcom's 2024 closed-sourcing forces a decision; Cloudberry is where the community and the lineage continued.
- PostgreSQL compatibility matters; the PostgreSQL 14 kernel keeps common extensions, tools, and SQL working.
- Data must stay on your own hardware or cloud account.

## Think twice when

- Nobody wants to operate a coordinator, segments, and mirrors; the managed cloud warehouses exist precisely to remove that work.
- Elasticity is the requirement; storage is coupled to segments, so scaling is a resize rather than a slider, unlike Snowflake or BigQuery.
- You need time travel, managed streaming ingest, or a vendor SLA; those arrive via ecosystem builds like SynxDB rather than the project.

## How it runs

Self-hosted MPP in the coordinator-and-segments model: the coordinator plans and distributes queries, segment instances each own a data slice, and mirror segments cover failover. Storage options span heap, append-optimized row and column, and PAX; PXF and FDWs reach external data. Resource groups police CPU, memory, and I/O per workload.

## Details

### General

| Attribute | Value |
| --- | --- |
| License | Open source (permissive) |
| SPDX identifier | Apache-2.0 |
| Deployment | Self-hosted |
| Operational complexity | High |
| Pricing | Free |
| Language | C |
| Repository | https://github.com/apache/cloudberry |
| Documentation | https://cloudberry.apache.org/docs/ |
| Stars | 1.4k |

### Data Warehouses

| Attribute | Value |
| --- | --- |
| Where it runs | Self-hosted anywhere; managed only through vendor builds like SynxDB Cloud on AWS |
| Compute and storage | MPP shared-nothing, coupled storage |
| Storage format | Heap, append-optimized row and column, and PAX; external tables via PXF and FDW |
| SQL dialect | PostgreSQL 14 |
| Streaming ingest | Via external tables: gpfdist, PXF or FDW; dynamic tables refresh on a cron |
| Concurrent users | Resource groups on cgroup v1 or v2, CPU, memory, I/O and transaction limits per group |
| Acceleration | ORCA cost-based optimizer; B-tree, bitmap and BRIN indexes; materialized and dynamic tables |
| Billing unit | None: self-hosted |
| Time travel | None |
| Access control | PostgreSQL roles and grants with row-level security policies; SCRAM passwords, TLS, audit logging |

## Capabilities

- [Data Warehouses](https://matca.io/capabilities/data-warehouse)

---

Source: https://matca.io/apache-cloudberry
Last updated: 2026-08-31T11:40:49.005Z