Re: Unexpected Performance for the Function simplify_function

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Unexpected Performance for the Function simplify_function
Дата
Msg-id CAKFQuwZoO1RtwasxwmmNE5beQsdYBuOZo=UueHD5D=i3PDNcJA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Unexpected Performance for the Function simplify_function  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
On Thursday, October 24, 2024, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Shiv Iyer <shiv@minervadb.com> writes:
> The query plans and results you shared illustrate the unexpected
> performance differences between using and bypassing the simplify_function()
> logic in PostgreSQL’s optimizer. Here’s an in-depth analysis and thoughts
> on optimizing this scenario:

Just out of curiosity, was this AI-generated?


Nowadays, failing the Turing Test means producing too comprehensive of an answer to a query/situation as opposed to looking too incapable.

The real question is what prompt did the author give to which tool, and maybe, if we are feeling generous, how much editing of the response was performed.

David J.

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