WarehousePG 6.x release notes v6.27.4

This section is adapted from the WarehousePG v6.x documentation

WarehousePG 6.x release notes

The WarehousePG documentation describes the latest version of WarehousePG 6.

Released: 7 April 2026

WarehousePG 6.27.4-WHPG includes the following new features, enhancements, bug fixes, and other changes:

Resolved critical stability issues in the ORCA optimizer including fixes for segmentation faults and infinite recursion.
Fixed an issue where unnecessary motion was created on query executor slices.
Corrected behavior and stability when running the execute on initplan function.
Removed role assertions in get_ao_compression_ratio() and aorow_compression_ratio_internal to allow the function to execute on query executors, enabling the use of gp_dist_random() to retrieve compression statistics from all segments.

Fixed a heap buffer overflow vulnerability in libpq for CVE-2025-12818 by hardening memory allocation against integer overflows. This change implements stricter size_t calculations for large, untrusted inputs to ensure allocated buffers are sufficient for their contents.

Released: 28 January 2026

WarehousePG 6.27.3-WHPG includes the following new features, enhancements, bug fixes, and other changes:

Made the ReScanForeignScan callback optional for Foreign Data Wrappers (FDWs) to simplify the implementation and improve compatibility for external data sources.
Removed the GUC_NO_SHOW_ALL flag for the archive_timeout configuration parameter to ensure the setting is correctly displayed in all system configuration views.

Released: 8 December 2025

WarehousePG 6.27.2-WHPG includes the following new features, enhancements, bug fixes, and other changes:

Restored the functionality of greenplum-abi-tests to ensure ongoing development stability and interface compatibility.
Adjusted ftsprobe logging to use WARNING severity for failure and retry exhaustion events, ensuring these critical messages are always visible regardless of gp_log_fts settings.

Resolved mirror promotion failures and fixed assertion failures caused by the incorrect application of the fmtId() function.
Improved error detection reliability in status_check cases and implemented checks for MergeAppend nodes in the share input mutator.
Optimized internal performance by transitioning to LWLocks for instrumentation headers and using pipes instead of sockets for immediate poll termination.
Fixed an issue where tables with corrupted reloptions could not be dropped due to compression validation errors being incorrectly raised during non-validation code paths.

EDB Postgres AI for WarehousePG

EDB Postgres AI for WarehousePG

Installing and Upgrading WarehousePG