WarehousePG 7.x release notes v7.4

Suggest edits

The WarehousePG documentation describes the latest version of WarehousePG 7.

VersionRelease date
7.4.0-WHPG7 April 2026
7.3.1-WHPG30 January 2026
7.3.0-WHPG14 November 2025
7.2.2-WHPG17 November 2025
7.2.1-WHPG15 May 2025

WarehousePG 7.4.0-WHPG

Released: 7 April 2026

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

New features

  • Introduced pg_stat_statements for WarehousePG, extending standard PostgreSQL statistics collection to include all segment nodes.
  • Implemented DISTRIBUTED COORDINATOR ONLY tables to allow metadata to reside exclusively on the coordinator node, supporting specialized use cases where extensions must access data during early-stage query processing before distributed execution begins.

Enhancements

  • Added automatic fallback to the Postgres planner when vchord indexes are present.
  • Simplified the gp_stat_progress_copy_summary view and corrected issues where NULL values were improperly handled.
  • Enabled the get_ao_compression_ratio() function to execute in query executors.
  • Optimized internal cluster communications by improving the performance of Interconnect (IC) UDP processes and eliminating stale file descriptor warnings, resulting in more stable and faster data exchange between nodes.

Bug fixes

  • Improved query planner accuracy for anti-joins and left anti-semi joins by resolving a double-calculation error in join selectivity. This fix resolves issues where underestimated join costs led to inefficient query plans, resulting in significantly faster performance for complex analytical workloads.
  • Resolved critical stability issues in the ORCA optimizer, including fixes for segmentation faults, infinite recursion, and improper motion creation on QE slices.
  • Fixed ORCA regr_count scalar subquery decorrelation to prevent planning errors during complex aggregations.
  • Resolved an issue where ORCA failed to handle views with unused CTEs after changes were made to underlying table structures.
  • Improved DXL translation by fixing the handling of required but unused columns.
  • Fixed gpcheckcat inconsistencies encountered when using the SCRAM-SHA-256 authentication algorithm.
  • Ensured initdb only evaluates errno when a system call explicitly fails, preventing successful directory operations from being incorrectly reported as errors due to residual error codes from previous tasks.
  • Ensured isolation2 test compatibility for Python 3.14 by explicitly setting the subprocess start method to fork, preventing cannot pickle TextIOWrapper errors caused by the change in Python's default process spawning behavior on Linux.

Security

  • Mitigated SQL injection risks in pg_dump and pg_dumpall for CVE-2025-8715 by ensuring object names containing newlines are properly sanitized before being written as comments in backup files, preventing a vulnerability where maliciously crafted names could execute arbitrary SQL during the restore process.
  • 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.

WarehousePG 7.3.1-WHPG

Released: 30 January 2026

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

Enhancements

  • Allowed parallel workers to retrieve combo command ids and distributed snapshots directly from Dynamic Shared Memory (DSM).
  • Implemented pipes instead of sockets to terminate poll() blocking immediately for faster process signaling.
  • Added native support for executing customscans within the engine.
  • Made the rescanforeignscan callback optional for foreign data wrappers to improve FDW compatibility.
  • Configured GDD to push transaction ids into waitgxids so the query dispatcher can wait on them effectively.
  • Appended the WarehousePG name to the end of the version string for better identification.
  • Replaced spinlocks with lwlocks at the instrumentation header to reduce CPU contention.
  • Implemented pipes instead of sockets to terminate poll() blocking immediately for faster process signaling.
  • Updated the build instructions for RHEL8 and RHEL9 systems.
  • Updated regression test outputs to reflect recent FDW rescan changes.

Bug fixes

  • Fixed a critical issue with shared snapshots in DSM to prevent potential data loss.
  • Resolved a crash in ORCA when processing percentile aggregates.
  • Fixed a crash and incorrect results when using distinct qualified aggregates (DQA) with a filter clause.
  • Initialized missing plannedstmt fields in ORCA to prevent execution errors.
  • Corrected the handling of required but unused columns during DXL translation.
  • Fixed an incorrect join type assignment when pulling up expression sub-links.
  • Adjusted the severity level to warning in ftsprobe.c under specific conditions to reduce log noise.
  • Removed the guc_no_show_all flag for the archive_timeout setting.
  • Fixed an invalid escape sequence in the recoveryinfo.py script.
  • Resolved an intermittent failure case in the pg_waldump tests.
  • Corrected the return type of gddctxgetmaxvid() to use DistributedTransactionId(uint64).
  • Removed the deprecated pkg_resources dependency from the Python environment.

WarehousePG 7.3.0-WHPG

Released: 14 November 2025

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

Enhancements

  • Enabled parallel workers context for index builds to improve creation speed.
  • Merged Postgres 12 llvm changes and implemented explicit llvmcontextref for JIT inlining.
  • Configured the system to insert WAL records uncompressed if compression fails, ensuring write continuity.
  • Updated the copy utility to print the specific errno for program pipes.
  • Prevented the sorting of in-memory tuples when a process has already been interrupted.
  • Enabled builds for the intarray and unaccent extensions.
  • Updated waitgxids to use int64 for better handling of transaction ids.
  • Added support for PL/Python2 testing.
  • Improved the reliability of error detection in status_check cases.
  • Updated the PR template and .editorconfig settings.

Bug fixes

  • High availability: Fixed mirror promotion failures related to WAL segment renaming.
  • Resolved a VACUUM issue on AOCS tables following an aborted ADD COLUMN transaction.
  • Corrected pg_exttable view outputs specifically for ARM systems.
  • Implemented recursive calls in the plan walker for MergeAppend to ensure plan integrity.
  • Fixed a logic error involving SubPlan PlaceHolderVar.
  • Removed extra blank lines in EXPLAIN output.
  • Silenced harmless fsync errors when parent directories are removed.
  • Fixed a NULL pointer error during COPY (SELECT) TO option validation.
  • Dispatched ICU collation comments correctly.
  • Stopped reporting compresstype, zlib, or zstd errors when not in the validation phase.
  • Fixed inconsistent test cases for REINDEX TABLE, REINDEX INDEX, and EXPLAIN FORMAT.
  • Fixed the gpcheckcat mix_distribution_policy test.
  • Replaced the deprecated Python pipes module.
  • Removed gsutil from developer requirements.

Security

WarehousePG 7.2.2-WHPG

Released: 17 November 2025

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

Enhancements

  • Enabled parallel workers context for index builds to reduce execution time.
  • Optimized resource usage by skipping the sorting of in-memory tuples when a process is interrupted.
  • Configured WAL records to be inserted uncompressed as a fallback if compression fails.
  • Enhanced diagnostic output by printing the specific errno for copy program pipes.
  • Improved concurrency handling by using int64 for waitgxids.
  • Enabled the unaccent extension by default.
  • Added PL/Python2 testing support for WarehousePG 7 environments.
  • Improved the reliability of error detection for status_check operations.

Bug fixes

  • Fixed a failure in mirror promotion caused by WAL segment renaming.
  • Resolved a vacuuming issue on AOCS tables that occurred after aborted add column transactions.
  • Corrected pg_exttable view data for ARM-based architectures.
  • Implemented recursive calls in the plan walker for mergeappend to ensure correct plan traversal.
  • Fixed a sub-plan bug related to placeholder variables.
  • Suppressed unnecessary blank lines in EXPLAIN output.
  • Prevented harmless fsync errors from being reported when parent directories are missing.
  • Ensured ICU collation comments are dispatched correctly to maintain metadata.
  • Stopped reporting compresstype errors during the non-validation phase.
  • Silenced zlib and zstd reloption errors during the non-validation phase.
  • Reverted the fault tolerance service (FTS) enablement for mirror-less clusters.
  • Resolved intermittent test failures in REINDEX TABLE and REINDEX INDEX cases.
  • Fixed an intermittent failure in the explain_format test case.
  • Fixed the gpcheckcat mix_distribution_policy test.
  • Removed the gsutil dependency from development requirements.

Security

WarehousePG 7.2.1-WHPG

Released: 15 May 2025 WarehousePG 7.2.1-WHPG includes the following new features, enhancements, bug fixes, and other changes:

Enhancements

  • Fixed a work_mem reference in hash aggregates to ensure planned memory is fully utilized and reduce unnecessary disk spills.

Bug fixes

  • Resolved a gpstart failure caused by a double free or corruption error when using OpenSSL 3.2.2.
  • Fixed a bug in the Postgres planner where correlated subqueries returned incorrect results due to improper placeholdervar handling.
  • Resolved an unexpected gang size error occasionally encountered in the Postgres planner.
  • Initialized attnumswithentries to prevent failures during concurrent-only (CO) table rewrites.

Security

← Prev

EDB Postgres AI for WarehousePG

↑ Up

EDB Postgres AI for WarehousePG

Next →

Installing and upgrading WarehousePG