Introduced release of the distributed DBMS Apache Cloudberry 2.2.0, which continues the development of open source codebase Greenplum DBMS, which was turned into a closed product by Broadcom after acquiring VMware. The project is still in the Apache incubator and will be transferred to the number of primary Apache projects once the infrastructure and maintainers are ready.
The Cloudberry DBMS is a distributed edition of the open PostgreSQL DBMS, optimized for performing analytical queries on large amounts of data (Data Warehouse). For parallel data processing, massively parallel architecture (MPP, massively parallel processing), providing storage scalability up to petabyte sizes by dividing data into segments and using a cluster from a group of servers to store and process it.
Among improvements in Apache Cloudberry 2.2.0:
- Bug fixes, vulnerability fixes and optimizations have been carried over from the PostgreSQL 14.4-14.10 releases (the Cloudberry 2.x branch is built on the PostgreSQL 14 codebase).
- Added six additions: diskquota, gp_stats_collector, gp_relsizes_stats, reject_partition_fullscan, try_convert and yezzey.
- Added interconnect extension providing summary counters from the UDPIFC protocol, accessible through the gp_interconnect_stats, gp_interconnect_stats_per_segment and gp_interconnect_stats_per_host views. The extension allows you to analyze statistics of interaction between nodes using SQL queries instead of parsing logs.
- The ORCA optimizer implements intra-segment parallel scanning of tables. The number of concurrently launched processors is configured through the max_parallel_workers_per_gather parameter.
- The ability to perform Full Join and Right Join operations in parallel has been provided.
- For queries containing join operations on multiple tables (JOIN), the AQUMV (Answer-Query-Using-Materialized-Views) optimization technique has been implemented.
- Added support for Rocky Linux 8/9/10 and Ubuntu 22.04/24.04. Support for Ubuntu 20.04 has been discontinued.
- The assembly of packages in DEB and RPM formats for x86_64 and ARM64 architectures has been automated.
- A table with PXF server statistics pxf_stat_activity has been added, as well as functions pxf_cancel_backend and pxf_interrupt_backend to stop external requests without restarting the server PXF.
- Added support for Java 17.
- Added the gpbackman utility for managing backups, as well as the gpbackup_exporter handler for exporting backup information to the Prometheus monitoring system.