Greenplum Database
greenplum.org
- Free plan
- Linux
- API
- Self-hosted
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.
Plans
Every plan and priceVMware Tanzu Greenplum
Greenplum Database (open source)
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.