Skip to the content
Know your tech before you buy it. Makers: get listed from $49/mo

Greenplum Database

greenplum.org

  • Free plan
  • Linux
  • API
  • Self-hosted
7.4 Club score Visit greenplum.org

What Greenplum Database is

Greenplum Database is an open-source data warehouse based on PostgreSQL for analytics, machine learning, and AI workloads at petabyte scale. Its massively parallel processing architecture spreads data and query processing across multiple servers: a coordinator divides queries among segment servers. Greenplum can use GPORCA alongside the PostgreSQL-based query planner. Storage options include append-optimized row or column formats, and column storage can be compressed.

PXF connectors provide access to Hadoop sources, object stores including Azure, Google Cloud Storage, MinIO, and S3, and SQL databases through JDBC. External tables can be queried or used to load outside data; PXF can also connect to data lakes and query Apache Iceberg foreign tables. Clients can use psql, ODBC, or JDBC, including standard PostgreSQL drivers for ODBC and JDBC applications. The project is released under the Apache 2 license and describes a cluster of a coordinator and multiple segment servers. The free open-source plan is available; commercial VMware Tanzu Greenplum pricing is on request. Documented access control supports object-level privileges, but not row-level or column-level access control.

Who it suits

Greenplum Database is aimed at teams building large analytical warehouses or working with enterprise analytics, machine learning, AI, vector and RAG workloads, or IoT data.

Good to know, and what to watch

  • MPP architecture distributes queries across multiple servers.
  • Supports compressed column-oriented storage.
  • PXF connects to object stores, Hadoop, and SQL databases.
  • External tables can query or load outside data.
  • Row-level and column-level access control are unsupported.
  • Commercial VMware Tanzu Greenplum pricing is on request.
  • The documented deployment uses a coordinator and multiple segment servers.

VMware Tanzu Greenplum

—

Greenplum Database (open source)

Free

Pricing on request

The verdict

Greenplum combines PostgreSQL-based analytics with distributed processing and connections to external data sources. Its object-level-only access control may not fit teams that need row-level or column-level permissions.

What the maker publishes

Architecture
Its MPP architecture distributes data and query processing across multiple servers, with a coordinator that divides queries among segment servers. source
Architecture
A Greenplum cluster has a coordinator and multiple segment servers; the coordinator divides queries into fragments that run on the segments. source
Client interfaces
The documentation lists psql, ODBC and JDBC client access, using standard PostgreSQL drivers for ODBC and JDBC applications. source
Commercial support
The maker describes the commercial Tanzu Greenplum offering as including 24x7 enterprise support. source
Data federation
The maker says PXF can connect Greenplum to data lakes and supports querying Apache Iceberg foreign tables. source
Deployment
The project repository describes a cluster made up of a coordinator server and multiple segment servers. source
Deployment
The maker lists deployment on public clouds including AWS, Microsoft Azure, and Google Cloud Platform, as well as VCF, OpenStack private clouds, and on-premises. source
Development platforms
The repository provides developer build instructions for Linux and macOS and points to instructions for building client tools on Windows. source
External data
PXF connectors provide access to Hadoop sources, object stores including Azure, Google Cloud Storage, MinIO and S3, and SQL databases through JDBC. source
External tables
External tables can be queried or used to load data from external sources into Greenplum. source
Integrations
The maker describes streaming ingestion with Tanzu Greenplum Streaming Server on Kubernetes and a certified standalone Apache NiFi connector for Greenplum 7. source
License
The project repository states that Greenplum Database is released under the Apache 2 license. source
Notable limit
Greenplum’s documented access control supports object-level privileges; row-level and column-level access control are not supported. source
Product
Greenplum Database is an open-source data warehouse based on PostgreSQL for analytics on petabyte-scale data. source
Purpose
Greenplum Database is an open-source, PostgreSQL-based data warehouse for analytics, machine learning, and AI. source
Query optimization
Greenplum can use GPORCA alongside the PostgreSQL-based query planner. source
Query optimization
GPORCA is a cost-based optimizer used alongside the PostgreSQL planner. source
Scale
The project describes Greenplum as providing analytics on petabyte-scale data volumes. source
Security
The maker states Tanzu Greenplum uses STIG hardening and FIPS 140-3 cryptographic modules for encryption at rest and in transit. source
Storage
It supports append-optimized row or column storage, and its column-oriented storage can be compressed. source
Support
The project repository directs users to online documentation and its wiki for further information. source
Use cases
The maker presents Greenplum for enterprise analytics, data warehousing, AI, vector and RAG workloads, and IoT applications. source
Workloads
The architecture is designed for large-scale analytical data warehouses and business intelligence workloads. source

Checked against the maker's pages on 9 Oct 2026.