Re: Performance issues with v18 SQL-language-function changes - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Performance issues with v18 SQL-language-function changes
Date
Msg-id Z__8snZ_09Kf2Zid@momjian.us
Whole thread Raw
In response to Re: Performance issues with v18 SQL-language-function changes  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Performance issues with v18 SQL-language-function changes
List pgsql-hackers
On Wed, Apr 16, 2025 at 01:43:46PM -0400, Tom Lane wrote:
> 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.

I was referencing the contrib initialization functions you converted to
use SQL-standard function bodies:

    commit 68ff25eef12
    Author: Tom Lane <tgl@sss.pgh.pa.us>
    Date:   Sun Dec 29 14:58:05 2024 -0500
    
        contrib/pageinspect: Use SQL-standard function bodies.
    
        In the same spirit as 969bbd0fa, 13e3796c9, 3f323eba8.
    
        Tom Lane and Ronan Dunklau
    
        Discussion: https://postgr.es/m/3316564.aeNJFYEL58@aivenlaptop

I thought that was what you were saying were now slower;  maybe I was
confused.

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  Do not let urgent matters crowd out time for investment in the future.



pgsql-hackers by date:

Previous
From: Renan Alves Fonseca
Date:
Subject: Prototype: Implement dead tuples xid histograms
Next
From: Tom Lane
Date:
Subject: Re: Performance issues with v18 SQL-language-function changes