Re: Release notes for February minor releases

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Justin Pryzby <pryzby(at)telsasoft(dot)com>
Cc: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: Release notes for February minor releases
Date: 2022-02-04 21:29:19
Message-ID: 433898.1644010159@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Justin Pryzby <pryzby(at)telsasoft(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2022-02-04 21:35:07 Re: Release notes for February minor releases
Previous Message walther 2022-02-04 21:28:51 Re: [PATCH] Add reloption for views to enable RLS