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:
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 the postgres_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.
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.