Re: regression in PG 15.1

Поиск
Список
Период
Сортировка
От Scott Ribe
Тема Re: regression in PG 15.1
Дата
Msg-id 4B29C00C-028D-43AE-98F8-793BFC461CA5@elevated-dev.com
обсуждение исходный текст
Ответ на Re: regression in PG 15.1  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: regression in PG 15.1  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
> On Nov 28, 2022, at 7:44 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> Why do you say this is a regression?  From what I know of the partition
> pruning logic (admittedly not a whole lot), I don't think we'd have
> ever pruned on the basis of such a constraint.

Because performance of the query tanked. If it's not a change in table pruning, then it's a change in whether/how/which
indexesare used. I guess I'll have to dig into it more and get back to the list--probably tomorrow. 

Meantime, thanks for the clue to help guide me here.




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

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: regression in PG 15.1
Следующее
От: Tom Lane
Дата:
Сообщение: Re: regression in PG 15.1