Re: Question about simple function folding optimization - Mailing list pgsql-hackers

From Joe Conway
Subject Re: Question about simple function folding optimization
Date
Msg-id 3E944337.2010601@joeconway.com
Whole thread Raw
In response to Re: Question about simple function folding optimization  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Question about simple function folding optimization  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane wrote:
> Hmm.  That's an unexpected downside of the recent change to inline
> simple SQL functions :-(.  The inlined expression no longer looks
> like a match to the index.
> 
> The simplest answer is probably to convert the function to plpgsql,
> which would probably give better performance for index access anyway.
> But I wonder whether any better answer is possible.  I don't want to
> give up on the inlining optimization --- anyone see another fix?
> 

Would changing the function from immutable to stable work (similar to 
the other day)?

Joe



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Question about simple function folding optimization
Next
From: Tom Lane
Date:
Subject: Re: Question about simple function folding optimization