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
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 |