Re: Release notes for February minor releases

From: Justin Pryzby <pryzby(at)telsasoft(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: Release notes for February minor releases
Date: 2022-02-04 21:02:14
Message-ID: 20220204210214.GR23027@telsasoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, Feb 04, 2022 at 02:58:59PM -0500, Tom Lane wrote:
> I've pushed the first draft for $SUBJECT at
>
> https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=ab22eea83169c8d0eb15050ce61cbe3d7dae4de6
>
> Please send comments/corrections by Sunday.

+ <para>
+ Build extended statistics for partitioned tables (Justin Pryzby)
+ </para>
+ <para>
+ A previous bug fix disabled building of extended statistics for
+ old-style inheritance trees, but it also prevented building them for
+ partitioned tables, which was an unnecessary restriction.
+ If you have created statistics objects for partitioned tables, you
+ may wish to explicitly <command>ANALYZE</command> those tables after
+ installing this update, rather than waiting for auto-analyze to do it.

Since autoanalyze still doesn't process partitioned tables, the last part
should be removed.

Probably it should say "..you *should* explicitly ANALYZE thse tables..".

+ <para>
+ Ignore extended statistics for inheritance trees (Justin Pryzby)
+ </para>
+ <para>
+ A previous bug fix disabled building of extended statistics for
+ old-style inheritance trees, but any existing statistics data was
+ not removed, and that data would become more and more out-of-date
+ over time. Adjust the planner to ignore such data. Extended
+ statistics for the individual child tables are still built and used,
+ however.
+ </para>

The issue here isn't that old stats were never updated. For inheritance, they
*were* updated with non-inherited stats (for SELECT FROM ONLY). But then
"SELECT FROM tbl*" used the stats anyway...

+ <para>
+ Fix failure of SP-GiST indexes when indexed column's data type is
+ binary-compatible with the declared input type of the operator class
+ (Tom Lane)
+ </para>

maybe: when *the*

--
Justin

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Swaha Miller 2022-02-04 21:04:27 Re: support for CREATE MODULE
Previous Message Swaha Miller 2022-02-04 20:52:08 Re: support for CREATE MODULE