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 theshardmanctl 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
andconfig update
commands to work on a cluster that was stopped usingshardmanctl stop
.Added the
--all
flag to theshardmanctl getconnstr
command to add information on replicas to the command output.Added new commands
nodes start
,nodes restart
andnodes stop
for nodes, as well asstart
andstop
for shards to shardmanctl.Extended permissions for the shardmand data directory.