E.5. Postgres Pro Enterprise 14.11.3
Release Date: 2024-04-08
E.5.1. Overview
This release is based on Postgres Pro Enterprise 14.11.2 and provides the following changes:
Increased the maximum value of the
slru_buffers_size_scale
configuration parameter to 9. In some high-load environments, the former maximum value was not sufficient and could result in query queuing and locks.Fixed incorrect HOT chain conversion from 32-bit to 64-bit after upgrading Postgres Pro Enterprise using pg_upgrade. The previous fix for this type of problem failed to account for changing the offset information after checking dead tuples.
Fixed inconsistency of the
XMAX
value and theXMAX_INVALID
hint bit of the tuple, which manifested itself in “missing chunk number 0 for toast value XXX in pg_toast_XXX” errors.Upgraded pgpro_pwr to version 4.5.
Upgraded pg_probackup to version 2.7.3 Enterprise, which provides optimizations and bug fixes. Notable changes are as follows:
Added the
--waldir
option to thecatchup
command, which allows you to specify the directory to write WAL files to.Fixed incremental restore of tables larger than 1GB. Checksum computation for file pages was fixed, so the tables will no longer be reread from the backup during restore.
Fixed an abnormal termination of pg_probackup upon a forced termination of a backup.
Fixed slow validation and restore of large databases by fixing file comparison. Previously, the file sorting algorithm used for the comparison could result in quadratic complexity.
Fixed an issue that could occur during a backup in the root of an S3 bucket.
E.5.2. Migration to Version 14.11.3
If you are upgrading from a Postgres Pro Enterprise release based on the same PostgreSQL major version, it is enough to install the new version into your current installation directory.
To migrate from PostgreSQL, as well as Postgres Pro Standard or Postgres Pro Enterprise based on a previous PostgreSQL major version, see the migration instructions for version 14.