23.07.2026

Greengage DB 7.5.0 product release

New ggrebalance cluster management utility, the pg_wait_sampling extension, and multiple stability, testing, and CI enhancements
  • Postgres core
    12
  • Supported systems
  • License
    Apache 2.0

Added a cluster management utility for shrinking and rebalancing operations (ggrebalance)

Added a new communication channel for metadata exchange between Query Executor processes and the Query Dispatcher

Incorporated the pg_wait_sampling extension

Added "rows out" reporting in EXPLAIN ANALYZE

Enabled transaction-level ALTER RESOURCE GROUP support

Added resource group support for parallel retrieve cursor sessions

Ported relfilenode tracking

Improved psql tab completion for various database objects

Improved Hash Aggregate performance by removing the work_mem memory cap, adjusting the disk-spill cost model, and dropping the hashagg_avoid_disk_plan GUC

Added support for ShareInputScan nodes inside InitPlans

Fixed cost estimation of bitmap scans in ORCA

Adjusted the GP_HLL_ERROR_MARGIN value

Fixed scanning of AO tables without columns

Added a pg_upgrade pre-check for 6.x GUCs removed in 7.x

Reported tables and columns removed from Greengage 7 before the upgrade

Adjusted pg_upgrade to support upgrading from Greengage 6.x to 7.x

Added a pg_upgrade pre-check for the gp_default_storage_options GUC

Fixed the RANK(1) clause appearing in the dump

Added a check for a missing support function for partitions before the upgrade

Added a check for EXECUTE ON COORDINATOR functions before the upgrade

Fixed file transfer for foreign tables in pg_upgrade

Fixed pg_dump transferring TOAST tables for partitioned tables

Fixed pg_dump not assigning OIDs for array types

Fixed pg_dump inconsistencies between 6.x and 7.x

Fixed pg_dump for partitioned tables with a dropped column

Fixed a pg_upgrade failure when extensions need to be updated

Allowed background workers to initialize database connections

Fixed an issue with SET LOCAL inside PL functions

Added a missing GRANT to gp_toolkit

Fixed an assert trigger when vacuuming an AO table after ggupgrade

Fixed an incorrect Host header when connecting to gpfdist through a Kubernetes Ingress

Added a volatile expression alert for replicated tables to gpcheckcat

Prohibited moving out of a resource group in bypass mode

Protected replicated tables with volatile functions from rewrite

Fixed ORCA incorrectly hardcoding segment 0 when scanning replicated tables for singleton slices

Fixed distribution by resjunk columns

Fixed pg_saslprep allocation in the backend

Added tracking of PQresult allocations in server code

Prevented ORCA from generating redundant redistributions on joins

Prohibited skip-level correlated queries in the Postgres planner

Prevented ORCA from losing distribution requests

Refactored the gpcheckcat query used to detect leaked temporary schemas

Fixed handling of paths with trailing slashes

Fixed the calculation of total_queue_duration in gp_toolkit.gp_resgroup_status

Fixed an ORCA panic on nonexistent hash opfamilies

Fixed infinite recursion in the ProcessUtility hook chain

Fixed resource group bypassing when using the extended protocol

Fixed a test expression referencing a non-projected nested subplan attribute

Fixed orphaned segment files for added and rolled-back columns in AOCS tables

Fixed a vacuum failure to clean up some AOCS table segment files

Updated the storage options setting for partitions

Reported resource groups to pg_stat_activity for segment backends

Fixed resource group auxiliary tools for cgroup v2 tests

Added scripts to test pg_upgrade migration in a demo cluster

Eliminated demo cluster creation before behave tests

Fixed the gpcheckcat test after switching to SCRAM password hashing

Fixed restoration of the /etc/hosts file

Made isolation2 tests runnable from any directory

Fixed isolation2 tests overwriting diffs

Fixed gpssh behave tests on Python 3

Installed pg_isolation2_regress for use in extension tests

Allowed background mode for arbitrary commands in isolation2

Compiled backend libpq for regress_gp.so

Enabled gpexpand behave tests

Deprecated the unused test_AppendOnlyHash_eviction_vs_just_marking_not_inuse GUC

Added test coverage for vacuum compaction after an aborted ADD COLUMN on AORO tables

Fixed ignored errors in ORCA unit tests

Made the temp_tablespaces test stable

Fixed the ORCA CCTETest unit test

Backported psql tab-completion TAP tests from PostgreSQL

Bumped the regression and JIT workflows

Bumped Package CI to v44

Ported the deb package upload workflow from the 6.x branch to 7.x

Made deb artifact and cache names OS-specific

Replaced the build matrix with branch-driven OS configuration

Implemented the CODEOWNERS approach

Used the Azure Ubuntu mirror in Docker builds

Adjusted @Skip tags for gpexpand behave CI tests

Enabled SQL dump collection after building a new image on the next branch

Replaced ubuntu-latest runners with ubuntu-24.04

Fixed the SQL dump repository name to be lowercase

Enabled log collection for hanging tests

Fixed the Greengage SQL dump workflow that was failing unexpectedly

Fixed a missing SQL dump directory

Bumped greengage-reusable-upload to the v21 tag

Optimized the Greengage 7 development image size

Synchronized the resource group CI between 6.x and 7.x

Bumped the resource group workflow version to v13

Ported Make packaging targets from the 6.x branch to 7.x

Copied default branch CI files

Fixed an out-of-space error by bumping workflow versions

Bumped the resource group workflow version

Bumped the behave tests workflow version

Skipped using the actions cache when a developer image is available

Disabled pushing to Docker Hub when credentials are missing

Added skip tags for features and bumped CI

Enabled ABI tests to always run for pull requests

Enabled the Allure renderer to always run

Ported the deb package release-upload implementation from the 6.x branch to 7.x

Disabled cancellation of behave tests