E.1. Postgres Pro Enterprise 17.2.2 #
Release Date: 2025-01-21
E.1.1. Overview #
This release is based on Postgres Pro Enterprise 17.2.1 and provides the following changes:
Fixed an issue where temporary tables could fail to grow when their size exceeded a segment boundary, which could manifest itself in “could not open file” errors.
Upgraded aqo to introduce the
automode, which behaves like thelearnmode but prevents memory overflow by implementing the least recently used (LRU) cache mechanism.Fixed a bug that caused the biha.nodes function to return an empty row for the node where it was called on.
Upgraded mamonsu to version 3.5.11 to provide support for pgpro_stats version 1.8.
Upgraded pgpro_multiplan to version 1.1, which provides the following new features:
Introduced
plan_hash, which is the internal plan identifier of a frozen plan.Added support for
templateplans and the wildcards feature. Now the pgpro_multiplan extension can create a template plan, which can be applied to the queries with table names matching thePOSIXregular expressions in thepgpro_multiplan.wildcardsconfiguration parameter.
Upgraded pgpro_stats to version 1.8.1, which provides the following improvements and fixes:
Implemented an optimization that lowers the locking time in some cases when copying metrics from the local memory to the shared memory.
Fixed an issue that could occur during session tracing and cause errors “could not write file ""pg_stat/pgpro_stats_filters.trace.tmp"": No such file or directory”. Concurrent writing from different sessions to a trace file is fixed now, so processes can write to the trace file in parallel without collisions.
Fixed an issue that could occur when a custom scan was used, which could cause an incorrect state of the query plan and could result in an error when pgpro_stats was involved.
E.1.2. Migration to Version 17.2.2 #
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 17.