A.9. Postgres Pro Shardman 14.11.2 #

Release date: 2024-04-18

This release provides new features, optimizations and bug fixes. Major changes are as follows:

A.9.1. Core and Extensions #

  • Added the foreign_analyze_interval setting, in seconds, indicating how often to gather foreign statistics during autovacuum.

  • Added a possibility to create a foreign key between a sharded and a global table or between two global tables with the ON DELETE CASCADE action.

  • Added support for MergeAppend node pruning in generic plans.

  • Added support for a pushdown (remote execution) of to_timestamp() functions.

  • Implemented global views. Fetching from a global view returns a union of rows from the corresponding local views with the rows fetched from each of the local view cluster nodes.

  • Added a description of Silk multiplexer diagnostics views.

  • Improved error messages related to updating cluster parameters.

A.9.2. Management Utilities #

  • Added the --no-validate and --skip-block-validation flags to the shardmanctl probackup restore command.

  • Improved the process of restore to a cluster compatible with the source one.

  • Added the shardmanctl probackup checkdb command to verify the Shardman cluster correctness by detecting physical and logical corruption.

  • Enabled shardmanctl set and config update commands to work on a cluster that was stopped using shardmanctl stop.

  • Added the --all flag to the shardmanctl getconnstr command to add information on replicas to the command output.

  • Added new commands nodes start, nodes restart and nodes stop for nodes, as well as start and stop for shards to shardmanctl.

  • Extended permissions for the shardmand data directory.

pdf