A.1. Postgres Pro Shardman 14.18.1 #
Release date: 2025-05-19
This release is based on PostgreSQL 14.18 and Shardman 14.17.2 and provides new features, optimizations and bug fixes. Major changes are as follows:
A.1.1. Core and Extensions #
Updated foreign scan cost estimation and added the postgres_fdw.estimate_indexscan parameter that allows estimating remote scan as index scan. Earlier it was always estimated as sequential scan.
Allow pushdown for the functions that depend on
IntervalStyle
. Removed thepostgres_fdw.enable_always_shippable
configuration parameter, now its mechanism is built-in for the Shardman foreign servers and disabled for any other foreign servers.Added the limitation for the foreign partitions that now cannot be added to the tables included in publications with
publish_via_partition_root
.Updated the planner that can now consider the parameterized nested loop join when creating a sharded table join plan.
Fixed a bug that previously resulted in failure while updating or deleting some commands on global tables.
Fixed a bug with partial aggregates pushdown that previously resulted in the incorrect
sum
calculation.Enhanced Silk performance for higher shardman.silk_unassigned_job_queue_size values.
Updated the supported version of pgpro_stats to 1.9-sdm4.
Updated the supported version of pgpro_pwr to 4.9.
A.1.2. Management Utilities #
Added the feature to validate a backup on a compatible cluster.
Updated the shardmanctl shard master set and shardmanctl shard master reset commands that now require confirmation when the master node is switched. Added the
--yes
option that confirms the operation instead of asking approval from the standard input.Fixed the CVE-2025-22871 vulnerability.
Fixed the GO-2025-3503 and GO-2025-3595 vulnerabilities.
Fixed an issue with the log level not changing with the
.env
file.