Skip to content
SPECIFICTION
Get listed

Greenplum Database

greenplum.org

Free plan LinuxAPISelf-hosted
Visit greenplum.org
Spec score 8.1 #7 of 27 in Data Warehouse Software

What it is

Greenplum Database is a PostgreSQL-based, open-source data warehouse for analytics, machine learning, and AI. Its architecture spreads data and query work across a cluster: a coordinator divides queries among segment servers. The project describes it for large analytical warehouses and business intelligence, including petabyte-scale data. Query planning can use GPORCA alongside the PostgreSQL-based planner. Storage options include append-optimized row and column formats, with compression for column storage. PXF connectors connect to Hadoop, 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 also supports querying Apache Iceberg foreign tables. Clients can connect through psql, ODBC, or JDBC. Greenplum is available as a free open-source project under Apache 2, while the commercial VMware Tanzu Greenplum offering is priced on request. It supports on-premises deployment and data lakes. Documented access control covers object privileges; row-level and column-level access controls are not supported.

Spec sheet

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

Plans and prices

Greenplum Database (open source) Free Open source · Apache 2 license Read 9 Oct 2026 · github.com
VMware Tanzu Greenplum Priced on request Contact sales · BYOL and hourly consumption models are listed for public cloud marketplaces Read 9 Oct 2026 · vmware.com

Every Greenplum Database plan and price →

Strong points and limits

Strong points

  • Free open-source plan at free
  • MPP cluster architecture for petabyte-scale analytics
  • Supports compressed column storage
  • PXF connects to object stores and SQL databases
  • Supports psql, ODBC, and JDBC clients

Limits

  • Commercial Tanzu pricing is on request
  • No row-level or column-level access control

Who it suits

Greenplum suits teams building large analytical warehouses or business intelligence systems, including analytics, machine learning, and AI workloads. Its cluster architecture and external data connections are relevant to organizations working with data lakes and multiple data sources.

Verdict

Greenplum combines PostgreSQL-based query planning with distributed processing and a broad set of external data connections. Readers should account for its object-level-only access control and request pricing for the commercial Tanzu offering.

Where Specifiction places it

Alternatives to Greenplum DatabaseAll alternatives →