From b6aaba34be95db7fb7530858b17ed44a9d363909 Mon Sep 17 00:00:00 2001 From: "Jonathan S. Katz" Date: Tue, 7 Nov 2023 09:00:11 -0500 Subject: [PATCH] Changes to the 2023-11-09 release Reported-by: Matthias van de Meent Reported-by: Noah Misch Reported-by: Jesper Pedersen --- .../current/20231109securityrelease.md | 28 +++++++++---------- 1 file changed, 14 insertions(+), 14 deletions(-) diff --git a/update_releases/current/20231109securityrelease.md b/update_releases/current/20231109securityrelease.md index 653dc0a..5998bcd 100644 --- a/update_releases/current/20231109securityrelease.md +++ b/update_releases/current/20231109securityrelease.md @@ -1,16 +1,10 @@ The PostgreSQL Global Development Group has released an update to all supported versions of PostgreSQL, including 16.1, 15.5, 14.10, 13.13, 12.17, and 11.22 -This release fixes three security vulnerabilities and over 55 bugs and reported +This release fixes three security vulnerabilities and over 55 bugs reported over the last several months. This release includes fixes for indexes where in certain cases, we advise -reindexing. Please see the "Update" section for more details. - -This is the **final release of PostgreSQL 11**. PostgreSQL 10 will no longer -receive -[security and bug fixes](https://www.postgresql.org/support/versioning/). -If you are running PostgreSQL 10 in a production environment, we suggest that -you make plans to upgrade. +reindexing. Please see the "Updating" section for more details. For the full list of changes, please review the [release notes](https://www.postgresql.org/docs/release/). @@ -95,7 +89,8 @@ columns. Please [reindex](https://www.postgresql.org/docs/current/sql-reindex.ht any B-tree index that includes an `interval` column after installing this update. * Provide more efficient indexing of `date`, `timestamptz`, and `timestamp` -values in BRIN indexes. While not required, we recommend +values in BRIN indexes when using a [`minmax_multi` opsclass](https://www.postgresql.org/docs/current/brin-builtin-opclasses.html). +While not required, we recommend [reindexing](https://www.postgresql.org/docs/current/sql-reindex.html) BRIN indexes that include these data types after installing this update. * Fix for bulk table insertion into partitioned tables. @@ -144,17 +139,22 @@ users are not required to dump and reload their database or use `pg_upgrade` in order to apply this update release; you may simply shutdown PostgreSQL and update its binaries. ------- -If you use [BRIN]((https://www.postgresql.org/docs/current/brin-intro.html)) -indexes to look up `NULL` values, you will need to [reindex](https://www.postgresql.org/docs/current/sql-reindex.html) -them after upgrading to this release. On PostgreSQL 12 and above, you can use +We recommend [reindexing](https://www.postgresql.org/docs/current/sql-reindex.html) +certain types of indexes after you apply this update, including: + +* GiST indexes +* B-tree indexes that use the `interval` data type +* BRIN indexes that use the `date`, `timestamptz`, and `timestamp` +data types and a +[`minmax_multi` opsclass](https://www.postgresql.org/docs/current/brin-builtin-opclasses.html) + +On PostgreSQL 12 and above, you can use [`REINDEX CONCURRENTLY`](https://www.postgresql.org/docs/current/sql-reindex.html) to avoid blocking writes to the affected index and table, for example: ``` REINDEX INDEX CONCURRENTLY your_index_name; ``` ----- Users who have skipped one or more update releases may need to run additional post-update steps; please see the release notes from earlier versions for -- 2.39.5