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