Blog
This article covers the execution side of the ggrebalance utility: the physical movement of primary and mirror segments between hosts in a Greengage DB cluster, the design of the rebalance state machine, operation status tracking, failure handling and reentrancy, rollbacks, practical operational recommendations, and a final comparison with alternative tools.
Alexander Kondakov07 Aug 2026
This article covers planning Greengage cluster rebalancing after shrink, decommissioning, and adding hosts: a formal placement model for primary and mirror segments, minimization of moves count, comparison of exact and heuristic algorithms, and implementing the planner in ggrebalance
Alexander Kondakov17 Jul 2026
Exploring a major Greengage upgrade from version 6 to 7: how pg_upgrade works, what steps are required to upgrade a cluster, how ggupgrade helps, and how much time file copying and hard link mode can save.
Olga Sergeeva26 Jun 2026
This post covers Greengage DB cluster shrink using ggrebalance: utility architecture, the FSM approach, safe data redistribution via INSERT, comparison with CTAS, rollback support, and performance test results.
Alexander Kondakov29 May 2026
ggrebalance: Part 3. Executing a rebalance operation
This article covers the execution side of the ggrebalance utility: the physical movement of primary and mirror segments between hosts in a Greengage DB cluster, the design of the rebalance state machine, operation status tracking, failure handling and reentrancy, rollbacks, practical operational recommendations, and a final comparison with alternative tools.
Alexander Kondakov07 Aug 2026
ggrebalance: Part 2. Planning a rebalance operation
This article covers planning Greengage cluster rebalancing after shrink, decommissioning, and adding hosts: a formal placement model for primary and mirror segments, minimization of moves count, comparison of exact and heuristic algorithms, and implementing the planner in ggrebalance
Alexander Kondakov17 Jul 2026
Major Greengage upgrade using pg_upgrade and ggupgrade
Exploring a major Greengage upgrade from version 6 to 7: how pg_upgrade works, what steps are required to upgrade a cluster, how ggupgrade helps, and how much time file copying and hard link mode can save.
Olga Sergeeva26 Jun 2026
ggrebalance: Part 1. Shrink
This post covers Greengage DB cluster shrink using ggrebalance: utility architecture, the FSM approach, safe data redistribution via INSERT, comparison with CTAS, rollback support, and performance test results.
Alexander Kondakov29 May 2026
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