Justin Pryzby <pryzby@telsasoft.com> writes:
> On Fri, Feb 04, 2022 at 02:58:59PM -0500, Tom Lane wrote:
>> Please send comments/corrections by Sunday.
[ assorted comments ]
Thanks for the corrections.
> + 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.
> 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...
I'm confused about this bit. Are we still building bogus stats for
inheritance parents, or has that stopped?
regards, tom lane