Re: Unexpected Performance for the Function simplify_function

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Shiv Iyer <shiv(at)minervadb(dot)com>
Cc: Ba Jinsheng <bajinsheng(at)u(dot)nus(dot)edu>, "pgsql-performance(at)lists(dot)postgresql(dot)org" <pgsql-performance(at)lists(dot)postgresql(dot)org>
Subject: Re: Unexpected Performance for the Function simplify_function
Date: 2024-10-24 20:51:15
Message-ID: 2596240.1729803075@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Shiv Iyer <shiv(at)minervadb(dot)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?

regards, tom lane

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message David G. Johnston 2024-10-24 21:05:00 Re: Unexpected Performance for the Function simplify_function
Previous Message Tom Lane 2024-10-24 20:49:18 Re: Unexpected Performance for the Function simplify_function