Postgres Professional, a leading Russian DBMS developer, announces the release of minor updates for Postgres Pro Shardman version 14.12.1.
Postgres Pro Shardman — a new distributed relational DBMS for high-load systems, suitable for the largest installations of tens and hundreds of TB, when a single server is insufficient. The DBMS allows dividing data into parts and distributing them across different servers — shards. At the same time, the solution provides built-in fault tolerance and guarantees compliance with ACID requirements: atomicity, consistency, isolation, and durability.
In this release, Postgres Pro Shardman has added new features, improved performance, and fixed several bugs. Key changes include:
Core and Extensions
- A REMOTE parameter has been added to the EXPLAIN command, which allows EXPLAIN output for queries executed on a remote server. This is enabled by default.
- Custom cost estimation logic has been implemented. It allows the planner to more often choose generic plans when similarities exist between generic and specialized.
- Support for excluding sections during execution for plan nodes performing data aggregation on external servers has been added. This optimization is primarily needed to eliminate sections in general plans.
- Cumulative metrics for network traffic between nodes in the Shardman cluster have been added to the view shardman.pg_stat_netusage.
- The pg_stat_activity view has been updated, which now shows the status of Shardman servicing processes.
Management Utilities
- Vulnerabilities CVE-2023-45288 and CVE-2023-44487 have been resolved.
- An error in the command shardmanctl cleanup, which prevented the deletion of replication groups, has been fixed.
- The output of the command shardmanctl forall has been improved in case of an empty result.
- A crash of the utility shardmand, which previously occurred if the Shardman cluster was not fully configured, has been eliminated.
Source: linux.org.ru
