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