A.17. 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.17.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 CASCADEaction.Added support for
MergeAppendnode 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.17.2. Management Utilities #
Added the
--no-validateand--skip-block-validationflags to theshardmanctl probackup restorecommand.Improved the process of
restoreto a cluster compatible with the source one.Added the
shardmanctl probackup checkdbcommand to verify the Shardman cluster correctness by detecting physical and logical corruption.Enabled shardmanctl
setandconfig updatecommands to work on a cluster that was stopped usingshardmanctl stop.Added the
--allflag to theshardmanctl getconnstrcommand to add information on replicas to the command output.Added new commands
nodes start,nodes restartandnodes stopfor nodes, as well asstartandstopfor shards to shardmanctl.Extended permissions for the shardmand data directory.