Re: Performance issues with v18 SQL-language-function changes

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: Performance issues with v18 SQL-language-function changes
Дата
Msg-id CAFj8pRDNm-BcJuqYe=A0FAVj3VaBAKSGBgKmX7Gjhjy94ZZ7Ng@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Performance issues with v18 SQL-language-function changes  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Hi

st 16. 4. 2025 v 19:43 odesílatel Tom Lane <tgl@sss.pgh.pa.us> napsal:
Bruce Momjian <bruce@momjian.us> writes:
> On Mon, Apr 14, 2025 at 10:38:29AM -0400, Robert Haas wrote:
>> I agree that we should do something about this. I haven't reviewed
>> your patches but the approach sounds broadly reasonable.

> Yep, we went down the road in PG 18 to convert syntax, and now we have
> to fix this, or we have to revert all the PG 18 syntax changes, which
> seems like a step backward.

I'm confused?  0dca5d68d didn't have anything to do with
syntax changes, just with when planning happens.

yes, and for most cases it has significant performance benefits.  For a few corner cases, there can be some slowdown that can be fixed by last Tom patches.

Regards

Pavel


                        regards, tom lane

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