ADB 7 releases

The release includes the following components: ADBM, ADB Control, and connectors (ADB ClickHouse, ADB to Kafka and Kafka to ADB, ADB to ADB). Offline installation is supported

Migrated ADB to Greengage DB

DBeaver has been adapted to work with Greengage DB. Use version 25.2.3 or later

Added support for Linux cgroup v2, allowing you to limit disk throughput

Implemented orphaned file cleanup

Added the ability to define a distribution key for Redistribute Motion when using foreign tables

Added support for LDAP authentication

Added support for LLVM 18

Implemented TLS options for PXF external tables and foreign data wrappers (FDWs)

Implemented ADBM 2.8.0

Implemented ADB Control 4.15.0

Refactored arenadata_toolkit. The extension has been aligned with the latest Greengage DB architecture, and several components have been reorganized with part of the functionality moved into the gp_toolkit extension

Implemented a precheck to ensure a standby coordinator cannot be added when mirroring is not enabled

Refactored OS parameter handling and added a precheck to validate required system settings

Added support for selecting group or spread mirroring

Added SSL support for connections between pxf_fdw and the PXF service

Enabled support for the DEXTRA_DYNAMIC_MEMORY_DEBUG macro

Disallowed inlining of CTEs containing DML operations

Raised a planner error for SELECT INTO queries containing modifying CTEs

Enabled JSON output for EXPLAIN ANALYZE statistics

Prevented WAL removal during recovery when archive_mode=always

Added an explicit error when specifying ENCODING for foreign-table columns

Added EXPLAIN ANALYZE statistics for queries with DML inside CTEs

Added a default transformation flag for gpfdist applied automatically when a table has no transformation level defined

Ensured gpcloud compatibility with OpenSSL 1.1.1

Added a check to ensure the previous expand action completed successfully before starting the next one

Fixed an issue where temporary schemas were not cleaned up after segment failures

Fixed an issue where pg_dump generated an invalid DROP EXTERNAL TABLE statement that prevented proper restoration

Fixed gplogfilter so that time-range filters correctly skip irrelevant files

Fixed an issue where disk space was not promptly reclaimed after dropping temporary tables

Fixed an issue where GUCs on segments were not updated when running gpstop -u

Fixed a crash when running EXPLAIN (ANALYZE, FORMAT JSON) for gp_toolkit.gp_table_size_skew_coefficients()

Fixed an issue where inserts failed if default_tablespace pointed to a non-existing tablespace

Fixed incorrect calculation of space used by spill files when multiple processes run in the same session

Fixed an issue where VACUUM could corrupt the bitmap index of an AO table on mirror segments

Fixed an issue where LDAP connections ignored hostssl and did not use SSL for the specified users

Fixed an issue preventing the use of wildcard characters in interconnect addresses

Fixed an issue in the tablefunc extension that prevented using DML queries

Fixed incorrect memory allocation when generating statistics for hash join queries

MADlib is now delivered as an extension

The output of the EXPLAIN command in JSON mode has been fixed to provide more accurate query execution details

GPDB compilation will now fail if compiler warnings occur, improving build quality

Implemented error reporting for invalid operations involving CTEs in the SELECT INTO statements

Interruption of LDAP requests by signals will no longer be treated as an authentication error, enhancing stability

Official support for Ubuntu 22.04 on x86-64 platform has been added

The query analysis logic has been moved to the PostgreSQL core, improving performance and integration

Simplified the dbid detection logic to improve the reliability of the pg_rewind command

Optimized the row counting mechanism in replicated tables for DML operations

Updated the data distribution logic to ensure proper handling of combined hash specifications

Python 3.11 is now supported, enhancing container operations

Updated the CTE processing mechanism to always materialize data if it is used outside of SELECT

Incorporated the latest timezone data updates for more accurate time zone management

Updated JIT support to enhance query performance in GPDB

Added documentation for running JIT tests and updated LLVM support to the latest versions

Fixed Dockerfile for proper execution of the GPDB 7 test suite and added support for Java 11

Resolved resource leaks during errors while executing the COPY TO/FROM PROGRAM commands

Addressed compilation warnings to improve compatibility with modern compilers

Corrected an issue that occurred when switching the access method to columnar for tables

Resolved an issue that caused a segmentation fault when calculating compression ratios for AO tables

Resolved an issue where temporary schemas were not properly cleaned up after segment failures

Addressed errors related to incorrect row access during the analysis of AOCO tables

The gpstop -u command logic has been updated to ensure that GUC parameters are properly applied on segments