From: | "Jonathan S(dot) Katz" <jkatz(at)postgresql(dot)org> |
---|---|
To: | Justin Pryzby <pryzby(at)telsasoft(dot)com> |
Cc: | pgsql-hackers(at)lists(dot)postgresql(dot)org |
Subject: | Re: 2022-02-10 release announcement draft |
Date: | 2022-02-08 01:43:43 |
Message-ID: | 65352007-58a7-7686-ca6b-cb76049b0519@postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On 2/6/22 10:20 PM, Justin Pryzby wrote:
> On Sun, Feb 06, 2022 at 08:01:02PM -0500, Jonathan S. Katz wrote:
>> Hi,
>>
>> Attached is a draft for the release announcement for the 2022-02-10
>> cumulative update release.
>>
>> Please review for technical accuracy or if you believe any items should be
>> added/removed. Please provide feedback no later than 2020-02-10 0:00 AoE[1].
>
> I guess you mean 2022 ;)
Maybe ;)
>> * The [`psql`](https://www.postgresql.org/docs/current/app-psql.html)
>> `\password` command now defaults to setting the password for to the role defined
>> by `CURRENT_USER`. Additionally, the role name is now included in the password
>> prompt.
>
> s/for to/for/
Done.
>> * 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.
>
> Instead of "you can fix this" , I suggest to say "you should run ANALYZE on
> those tables to collect updated statistics."
I opted for most of this suggestion.
> It should say "not process these TABLES" (not stats), and should not say "that
> are using extended statistics" since partitioned tables should be manually
> analyzed whether or not they have extended stats.
>
> It's good to say "..you should periodically run ANALYZE on partitioned tables
> to collect updated statistics." (even though this patch doesn't change that).
I reread the release note an agree, I misinterpreted this. I updated the
language.
>
>> * Fix crash with [multiranges](https://www.postgresql.org/docs/current/rangetypes.html)
>> when extracting a variable-length data types.
>
> remove "a" or s/types/types/
Fixed.
>> * Disallow altering data type of a partitioned table's columns when the
>> partitioned table's row type is used as a composite type elsewhere.
>
> the data types ?
This is correct, per 7ead9925f
I've attached the updated copy. Thanks!
Jonathan
Attachment | Content-Type | Size |
---|---|---|
20220210updaterelease.md | text/plain | 5.2 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Paquier | 2022-02-08 01:44:07 | Re: GUC flags |
Previous Message | Tom Lane | 2022-02-08 01:42:09 | Re: [RFC] building postgres with meson - perl embedding |