Release of Apache Cloudberry 2.2.0, an open alternative to the Greenplum DBMS

The release of the distributed database Apache Cloudberry 2.2.0 has been introduced, continuing the development of the open-source codebase of the Greenplum database, which was turned into a closed product by Broadcom after acquiring VMware. The project is currently in the Apache incubator and will be transitioned to a primary Apache project once the infrastructure and support are ready.

The Cloudberry DBMS is a distributed edition of the open-source PostgreSQL DBMS, optimized for executing analytical queries over large datasets (Data Warehouse). It utilizes a massively parallel processing (MPP) architecture for parallel data processing, ensuring the scalability of the repository to petabyte sizes by segmenting data and employing a cluster of nodes for their storage and processing. servers.

Among the improvements in Apache Cloudberry 2.2.0:

• Bug fixes, vulnerability patches, and optimizations from PostgreSQL releases 14.4-14.10 have been incorporated (the Cloudberry 2.x branch is built on the PostgreSQL 14 codebase).
• Six extensions have been added: diskquota, gp_stats_collector, gp_relsizes_stats, reject_partition_fullscan, try_convert, and yezzey.
• The interconnect extension has been added, providing aggregated counters from the UDPIFC protocol, accessible through the views gp_interconnect_stats, gp_interconnect_stats_per_segment, and gp_interconnect_stats_per_host. This extension allows the analysis of interaction statistics between nodes using SQL queries instead of log parsing.
• The ORCA optimizer implements intra-segment parallel table scanning. The number of concurrently running handlers is configurable via the max_parallel_workers_per_gather parameter.
• Support has been provided for parallel execution of Full Join and Right Join operations.
• For queries containing JOIN operations across multiple tables, the AQUMV (Answer-Query-Using-Materialized-Views) optimization technique has been implemented.
• Support for Rocky Linux distributions 8/9/10 and Ubuntu 22.04/24.04 has been added. Support for Ubuntu 20.04 has been discontinued.
• The automated packaging process in DEB and RPM formats for x86_64 and ARM64 architectures has been implemented.
• A table with statistics for the PXF server pxf_stat_activity has been added, along with the functions pxf_cancel_backend and pxf_interrupt_backend to stop external queries without a restart. server PXF.
• Support for Java 17 has been added.
• The gpbackman utility for managing backups has been added, as well as the gpbackup_exporter handler for exporting backup information to the Prometheus monitoring system.
• The first release of cloudberry-go-libs, a set of Go language libraries used in Apache Cloudberry, has been prepared.

Source: opennet.ru