Release date: 2023-09-11
CAUTION: This release requires cluster reinit because of a change in system catalog structure.
Postgres core and extensions:
Pushdown support for comparison expressions on row types.
Improved vacuum efficiency with optimized global horizont selection.
Global sequences switched to non-transactional sub-interval allocation to avoid deadlocks and serialization errors in concurrent transactions.
Reduced memory consumption for big transactions with many queries by limiting the number of opened cursors.
Fixed deadlock detector: added more uncovered cases of distributed deadlocks.
Fixed resolution of prepared transactions: lwlocks are released properly in case of errors during iteration on prepared xacts list.
Various bug fixes including the fix for freezes in multiplexing transport (silk) in some cases.
Parameters broadcast_ddl and sync_schema are ignored in config and allowed only on a session level.
Management utilities:
Ability to specify preferred master node in manual topology mode.
Added /master and /replica https endpoints in shardmand.
New shardmanctl bench command to generate data and run pgbench on the cluster.
Safer cluster spec format and config verification command.
Support for new features in shardmanctl load:
Sub-partitioned tables
Roles and grants
Table order priorities
Null string specification
Ability to log detailed sql
Support for ssl authorization of postgres and repl users.
Various bug fixes including the fixes for broken replica promotion in some cases.