Postgres Pro Standard 13.3.1: release notes

Overview

This release is based on PostgreSQL 13.3 and Postgres Pro Standard 13.2.2. All improvements inherited from PostgreSQL 13.3 are listed in PostgreSQL 13.3 Release Notes. Other major changes and enhancements are as follows:

  • Upgraded PTRACK to use a different algorithm for tracking changed pages. This greatly reduces the number of false positives among the changed pages tracked in the PTRACK map and hence the size of PTRACK backups.

  • Fixed a bug that caused queries to fail with an error “geqo failed to make a valid plan” after updating statistics with VACUUM ANALYZE when enable_compound_index_stats was on.

  • Ended support for Ubuntu 16.04 and added support for Ubuntu 21.04.

  • Fixed an issue of installing Postgres Pro on Alt Linux 8.2. For this OS, Postgres Pro now provides a separate package repository, which is different from the repositories of earlier Alt Linux versions.

  • Improved the planner's algorithm of self-join selectivity calculation, which ensures more accurate estimates of the number of rows after joins.

  • Upgraded mamonsu to version 2.7.1.

  • Upgraded pgpro_controldata to version 13.2.0.

  • On Windows systems, fixed an issue with updating temporary files for statistics if they are currently in use.

Migration to Version 13.3.1

If you are upgrading from Postgres Pro Standard based on the same PostgreSQL major version, it is enough to install the new version into your current installation directory.

When upgrading from Postgres Pro versions 13.2.1 or lower, rebuild indexes containing at least one included column of type for which the collation was defined in the table.

If you are upgrading from Postgres Pro versions 13.2.2 or lower and take PTRACK backups using pg_probackup, retake a full backup after upgrade.

To migrate from PostgreSQL or a Postgres Pro Standard release based on a previous PostgreSQL major version, see the instructions in Postgres Pro Standard 13.1.1 Release Notes.