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 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.

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.