From 4220320677d0a72f41aa8c1b864b638b80fa5eef Mon Sep 17 00:00:00 2001 From: "Jonathan S. Katz" Date: Mon, 7 Feb 2022 20:39:48 -0500 Subject: [PATCH] Adjusted 2022-02-10 release announcement per feedback Reviewe-by: Justin Pryzby --- update_releases/current/20220210updaterelease.md | 15 ++++++++------- 1 file changed, 8 insertions(+), 7 deletions(-) diff --git a/update_releases/current/20220210updaterelease.md b/update_releases/current/20220210updaterelease.md index 895e8e8..54e206f 100644 --- a/update_releases/current/20220210updaterelease.md +++ b/update_releases/current/20220210updaterelease.md @@ -25,19 +25,20 @@ indexes to prevent corruption. You can fix any TOAST indexes by [reindexing](https://www.postgresql.org/docs/current/sql-reindex.html) them again. * The [`psql`](https://www.postgresql.org/docs/current/app-psql.html) -`\password` command now defaults to setting the password for to the role defined +`\password` command now defaults to setting the password for the role defined by `CURRENT_USER`. Additionally, the role name is now included in the password prompt. * Build extended statistics for partitioned tables. If you previously added -extended statistics to a partitioned table, you can fix this by running -[`ANALYZE`](https://www.postgresql.org/docs/current/sql-analyze.html). -[`autovacuum`](https://www.postgresql.org/docs/current/routine-vacuuming.html#AUTOVACUUM) -currently does not process these statistics, so you must periodically run -`ANALYZE` on any partitioned tables that are using extended statistics. +extended statistics to a partitioned table, you should run +[`ANALYZE`](https://www.postgresql.org/docs/current/sql-analyze.html) on those +tables. +As [`autovacuum`](https://www.postgresql.org/docs/current/routine-vacuuming.html#AUTOVACUUM) +currently does not process partitioned tables, you must periodically run +`ANALYZE` on any partitioned tables to update their statistics. * Fix crash with [`ALTER STATISTICS`](https://www.postgresql.org/docs/current/sql-alterstatistics.html) when the statistics object is dropped concurrently. * Fix crash with [multiranges](https://www.postgresql.org/docs/current/rangetypes.html) -when extracting a variable-length data types. +when extracting variable-length data types. * Several fixes to the query planner that lead to incorrect query results. * Several fixes for query plan [memoization](https://www.postgresql.org/docs/current/runtime-config-query.html#GUC-ENABLE-MEMOIZE). * Fix startup of a physical replica to tolerate transaction ID wraparound. -- 2.39.5