E.3. Postgres Pro Standard 16.1.1 #

Release Date: 2023-11-30

E.3.1. Overview #

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

  • Added the vacuum_update_datfrozenxid_only_when_needed configuration parameter to improve the performance when vacuuming a large number of tables.

  • Added support for ALT SP Release 10.

  • Added support for Ubuntu 23.10.

  • Fixed an internal issue that could arise when an index relation was moved to a different namespace similarly to a plain relation.

  • Fixed too long planning that could take place when JOIN and index increased the number of variants to consider. Planning time was reduced by indexing equivalence classes and members of them.

  • Upgraded pgbouncer to version 1.20.1.

  • Upgraded PTRACK to version 2.5.1 Enterprise.

E.3.2. Migration to Version 16.1.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.

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