A.13. 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.13.1. Core and Extensions #
Added a new configuration parameter
shardman.silk-flow-controlthat 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_settingsthat enables cluster-wide synchronization of configuration parameters set by user.Added a new configuration parameter
shardman.sync_cluster_settings_blacklistthat 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 STATISTICSfor 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
DEFERRABLEconstraints for global tables that is now allowed.Added a new field
CSNXidMap_last_trimto theshardman.pg_stat_csnview that shows when the most recentshardman.trim_csnxid_map()function was called.
A.13.2. Management Utilities #
Added the shardmanctl psql command that creates a connection to the first available master node if no options are specified. If
--shardis specified, the connection is installed with the shard current master.Enabled the
lz4compression 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
DataDirdirectory.Fixed a bug that previously resulted in primary server switching to a replica after restart. Also, added a new option
--no-waitto theshardmanctl restartcommand (disabled by default).