Justin Pryzby <pry...@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