A.10. Postgres Pro Shardman 14.15.1 #
Release date: 2024-11-25
This release provides new features, optimizations and bug fixes. Major changes are as follows:
A.10.1. Core and Extensions #
Added a new metric to the
shardman.pg_stat_csnview that counts transactions with an exceeded time in theinDoubtstate.Added new fields to the shardman.silk_pending_jobs view:
query,pending_queue_bytes, andpending_queue_messagesfor the first queued message, the pending queue size, in bytes, and the number of pending queue messages.Added tracing for the queries processed via the Silk transport and added a new configuration parameter shardman.silk_tracepoints that enables it.
Updated the function
current_datethat now can be pre-evaluated locally on coordinator.timestampandtimestamptzcomparisons are now considered safe for the remote execution.Added pg_query_state support.
Introduced cluster-wide advisory locks which are recommended locks that have application-defined meanings. Also added advisory lock functions.
Fixed a bug that previously resulted in uncontrolled memory usage and allocation by
silkwormwhile processing messages.Fixed a bug that previously resulted in unstable Silk connectivity and potential queries hanging in case
shardman.silk_flow_controlwas enabled.
A.10.2. Management Utilities #
Added a new shardmanctl history command that shows history of the commands that updated the cluster. By default, they are sorted from the most recent to the oldest ones.
Updated etcd version to 3.5.13.
Added the normalization for the rebalance process. It allows properly resuming it if it was interrupted.
Added a new feature for the shardmand application that allows configuring a port in
sdmspec.jsonwith encryption option.Updated the PostgreSQL parameter validation mechanism that now uses data returned by PostgreSQL instance.