A.5. Postgres Pro Shardman 14.13.2 #
Release date: 2024-10-22
This release provides new features, optimizations and bug fixes. Major changes are as follows:
A.5.1. Core and Extensions #
Added a new configuration parameter
shardman.silk-flow-control
that controls the mode of handling read events. It has three possible values:none
,round_robin
, andshortest_job_first
.Added the shardman.pg_stat_foreign_stat_bytes view that shows the amount of statistics for foreign relations transferred over the network between Shardman cluster nodes. Also added the corresponding global view
shardman.gv_stat_foreign_bytes
.Added a new configuration parameter
shardman.sync_cluster_settings
that enables cluster-wide synchronization of configuration parameters set by user.Added a new configuration parameter
shardman.sync_cluster_settings_blacklist
that excludes the options not to be propagated to a remote cluster.Added a new configuration parameter
enable_sql_func_custom_plans
. If enabled, custom plans can be created to run SQL functions. Enabled by default for the new clusters and disabled for the old ones.Fixed a bug that previously resulted in shardmand hanging in case an etcd cluster looses quorum.
Allowed
ALTER COLUMN SET STATISTICS
for global and sharded tables.Introduces the limitation for the privilege management per columns that is not supported for global tables.
Introduced a limitation that global tables cannot inherit other tables.
Removed the limitation for using of
DEFERRABLE
constraints for global tables that is now allowed.Added a new field
CSNXidMap_last_trim
to theshardman.pg_stat_csn
view that shows when the most recentshardman.trim_csnxid_map()
function was called.
A.5.2. Management Utilities #
Added the shardmanctl psql command that creates a connection to the first available master node if no options are specified. If
--shard
is specified, the connection is installed with the shard current master.Enabled the
lz4
compression method for thedefault_toast_compression
.Fixed a bug that previously resulted in a failure of the shardmanctl probackup checkdb command when a custom port was specified in Shardman configuration.
Fixed a shardmand bug that previously resulted in the application failing with PANIC-level error in case of insufficient access rights to the
DataDir
directory.Fixed a bug that previously resulted in primary server switching to a replica after restart. Also, added a new option
--no-wait
to theshardmanctl restart
command (disabled by default).