Re: Unexpected Performance for the Function simplify_function

From: Greg Sabino Mullane <htamfids(at)gmail(dot)com>
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 23:09:06
Message-ID: CAKAnmmJXMS_fkFKckYCLskaYeTz9YgAuofkaigXgue9AbO9ECw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Thu, Oct 24, 2024 at 3:49 PM Shiv Iyer <shiv(at)minervadb(dot)com> wrote:

> Hello,
>
>
> 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:
>

Please don't post LLM-generated answers to this list. Or any Postgres list.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Andrei Lepikhov 2024-10-25 02:13:34 Re: Unexpected Performance for the Function simplify_function
Previous Message David G. Johnston 2024-10-24 21:05:00 Re: Unexpected Performance for the Function simplify_function