Re: pg15 inherited stats expressions: cache lookup failed for statistics object

Поиск
Список
Период
Сортировка
От Justin Pryzby
Тема Re: pg15 inherited stats expressions: cache lookup failed for statistics object
Дата
Msg-id 20221101131240.GW16921@telsasoft.com
обсуждение исходный текст
Ответ на Re: pg15 inherited stats expressions: cache lookup failed for statistics object  (Richard Guo <guofenglinux@gmail.com>)
Ответы Re: pg15 inherited stats expressions: cache lookup failed for statistics object  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Tue, Nov 01, 2022 at 05:33:24PM +0800, Richard Guo wrote:
> On Mon, Oct 31, 2022 at 1:33 PM Michael Paquier <michael@paquier.xyz> wrote:
> 
> > On Mon, Oct 31, 2022 at 01:12:09PM +0800, Richard Guo wrote:
> > > BTW, I noticed a micro-optimization opportunity in examine_variable that
> > > we can fetch the RangeTblEntry for 'onerel' outside the foreach loop
> > > when iterating the extended stats so that we can do it only once rather
> > > than for each stat.
> >
> > Isn't that the kind of thing where we'd better have some regression
> > coverage?
> 
> Yeah, we need to have some regression tests for that.  I come up with a
> case in stats_ext like below

Well done

> This case should be able to cover both expression stats and ndistinct
> stats.  Hence, attach v2 patch.

Thanks for finishing it up.

I added a CF entry and marked RFC.
This should be included in v15.1.

-- 
Justin



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Justin Pryzby
Дата:
Сообщение: Re: pg_upgrade allows itself to be run twice
Следующее
От: Tom Lane
Дата:
Сообщение: Re: real/float example for testlibpq3