Greengage DB
Based on Greenplum Database Software
Greengage DB (Greengage Database)
An open-source massively parallel processing analytical DBMS based on Greenplum database software (which in turn is built on PostgreSQL). The Greengage DB project was started after Greenplum had become a proprietary product in May 2024.
Backward compatibility
Full compatibility with the latest minor versions of Greenplum 6 and 7
Open Source
Open Source solution licensed under ASF 2.0
Transparency
Contribute and evolve project with full access to the source code
Scalability
Ideal for fast-growing data volumes providing horizontal scalability
Community support
Our community is always ready to help you with your questions about the database
Easy integration
Process existing data from warehouses in Greengage using a bunch of connectors, protocols, and data formats
Target features
Planned product features under development
Expand & Shrink
Scale cluster horizontally by dynamic expand and shrink functionality
Legacy GP refactoring
Move Greengage-specific code base into PostgreSQL extensions to simplify the process of upgrading the PostgreSQL major version
Kernel upgrade to PostgreSQL 16
Greengage allows fast and transparent upgrade to PostgreSQL 16
Enhanced pgAudit
Extend security protection with flexible audit functionality
Advanced password check
Protect data with advanced password policy
Auto failover
Automated switchover from Master to Standby in case of failure
Roadmap
{Initial Greengage 6.X, 7.X releases with renaming}
- Product renaming
- Launch web site greengagedb.org
- Documentation site
{Migration from GP to GREENGAGE}
- Make CI/CD
- Migrate ADB to Greengage
- Public binaries
- Repository documentation updates
{Preparation for PG upgrade}
- Deleting orphaned files
- Distribution key support for foreign tables
- DBeaver integration
{GREENGAGE Release before core upgrade}
- Greengage 8 (alpha1)
- Prometheus exporter
- ggrebalance
- Apache Iceberg support in PXF
- Beekeeper studio integration
- pg_cron
{Upgrade PostgreSQL and automation}
- Greengage 8 (alpha2)
- Auto-partitioning
- Tiered storage for partitioned tables
- Auto-failover
- Readonly cluster
{Feature roadmap}
- Greengage 8 (rc)
- PXF Cluster
- duckdb_fdw extension
- parallel execution
- Codegen / JIT materialisation
Blog
Technical publications from our team, as well as latest news on Greengage
Greengage DB 6 update and other news
Let's discuss the main changes in Greengage DB 6.30.1 product release and other updates
Greengage Team16 Mar 2026
What has been going on with shrink and Iceberg connector
In this article, we will share some details of working on new Greengage features such as shrink and expand, improved foreign tables inserts, and developing Apache Iceberg integration (Greengage-to-Iceberg connector).
Andrey Savitskiy17 Dec 2025
Greengage DB backup and recovery. Part 2
In this article, we consider some application scenarios to be taken into account when implementing the backup system for a Greengage DB cluster
Dmitry Voronkov10 Nov 2025
How to contribute to Greengage DB
In this article, we discuss how you can participate in the development of the Greengage DB project and become a part of the community
Greengage Team26 Sep 2025
Evaluating lock-free list approach
In this article, we describe how we developed and tested a lock-free approach as a part of the major work of implementing orphaned files removal feature. Take a peek inside our development team’s process while evaluating this feature
Roman Eskin18 Jul 2025
Deleting orphaned files
In this article, we talk about how we solved the problem of deleting orphaned files — data files that are not associated with any tables in a database, but may remain on the file system after a backend process crash
Andrey Savitskiy20 Jun 2025
Greengage DB video quick start guide published
Now, we are also creating video articles as one more way to share information with Greengage DB users
Greengage Team17 Jun 2025
Greengage DB backup and recovery
In this article, we discuss an approach to data backup and restore in a distributed system, using Greengage DB as an example
Dmitry Voronkov03 Jun 2025
New documentation release for Greengage DB 6
Let's discuss the update of the documentation for Greengage DB version 6, and also briefly talk about the process of creating the Greengage DB documentation and our further plans for its development
Greengage Team12 May 2025
Greengage scaling approach
In this article, we consider approaches to cluster scaling in Greengage DB and define the base requirements to the utilities that are currently in development
Andrey Savitskiy07 Feb 2025
Greengage DB released initial versions 6.28.0 and 7.3.0
The first versions of Greengage DB are available to users
Greengage Team31 Jan 2025
Separating Orca into a Postgres extension: purpose and implementation details
In this article, we will talk about why we decided to move the Orca query planner from the core of Greengage Database (based on Greenplum) to an extension and how we implemented it
Roman Eskin27 Dec 2024
Greenplum vs Citus. Part 2
This article is a continuation of the comparison of Greenplum with Citus. Here, we discuss data distribution and cluster balancing
Andrey Savitskiy22 Nov 2024
Greenplum vs Citus. Part 1
With this article, we open a series of materials dedicated to a comparative review of distributed DBMS technologies. Let’s start with a comparison of Greenplum with Citus
Andrey Savitskiy19 Sep 2024
Greengage DB launched as open-source alternative to proprietary Greenplum
We're happy to announce the start of the Greengage DB project
Greengage Team19 Sep 2024