Disabled the system startup timeout by setting the TimeoutSec parameter to 0 in systemd. Previously, big databases could fail to start within the specified timeout.

Reduced logging level during a specified restore point creation at a checkpoint timeout for inactive bases only. It allows removing excessive log messages.

Improved performance of subsystems on top of SLRU. This includes improvements for the LWLocks that changed the locking mode for the SLRU banks, so that each bank uses a separate LWLock. This results in increased scalability. Also, a new concurrency model for SLRU implementation that uses atomic reads and writes is proposed.

Added the cfs_log_verbose configuration parameter that controls the CFS log level of defragmentation messages. It allows reducing the number of CFS messages in the log file.

Added the cfs_gc_lock_file configuration parameter that sets the path to the lock file to be used to ensure running only one garbage collection worker at a time for several Postgres Pro servers.

Added the xml_parse_huge configuration parameter that allows allocating up to 1 GB of memory for processing XML data.

Fixed a bug resulting in error “cache lookup failed for collation 128”. Now, for the additional INCLUDE index columns, collation is ignored.

Fixed two planner issues. An expression duplication issue previously caused underestimation of node selectivity and cost in some cases, which could lead to a choice of a suboptimal plan. Another issue — the selectivity overestimation for an AppendOr node was caused by its subnode selectivity overestimation and led to the plan cost overestimation.

Fixed an issue of not streaming certain data to a subscriber by a logical replication after executing the ALTER PUBLICATION pub ADD TABLE tab command. The root cause of the issue was an insufficient interlocking between ALTER PUBLICATION and taking a snapshot.

Fixed an issue with the automatic aggressive vacuum being triggered too often. Now, an aggressive vacuum scan will only occur for any table with multixact-age strictly greater than autovacuum_multixact_freeze_max_age.

Added support for Astra Linux 1.8 and ended support for Astra Linux Orel 2.12, Astra Linux Smolensk 1.6.

Added support for Red OS Murom 8 and ended support for Red OS Murom 7.2.

Added support for Ubuntu 24.04.

Upgraded mamonsu to version 3.5.8, which provides optimizations and bugfixes. Notable changes are as follows:

Upgraded orafce to version 4.10.0.

Upgraded pg_probackup to version 2.8.0 Enterprise, which provides new features, optimizations and bug fixes. Notable changes are as follows:

Added the pgv_exists_elem function to pg_variables that checks whether an element with a key exists in a general collection.

Upgraded pgpro_stats to version 1.7.1, which provides optimizations and bug fixes. Notable changes are as follows:

Fixed an error “ERROR: query failed: ERROR: tablespace "XXXX" does not exist” that could occur when the pg_repack command was trying to reorganize tables in a tablespace whose name started with a digit. The root cause of the issue was that pg_repack expected extra quotes.

Added the --save-fullpage option to pg_waldump. It allows saving full-page images included in WAL records into a given target directory.