Re: Optimze usage of immutable functions as relation - Mailing list pgsql-hackers

From Alexander Kuzmenkov
Subject Re: Optimze usage of immutable functions as relation
Date
Msg-id 3f7fda2f-1cdc-8ad3-e3c9-c2436fb5d509@postgrespro.ru
Whole thread Raw
In response to Re: Optimze usage of immutable functions as relation  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Optimze usage of immutable functions as relation
List pgsql-hackers
On 11/16/18 22:03, Tom Lane wrote:
> A possible fix for this is to do eval_const_expressions() on
> function RTE expressions at this stage (and then not need to
> do it later), and then pull up only when we find that the
> RTE expression has been reduced to a single Const.


Attached is a patch that does this, and transforms RTE_FUCTION that was 
reduced to a single Const into an RTE_RESULT.

Not sure it does everything correctly, but some basic cases work. In 
particular, I don't understand whether it needs any handling of "append 
relations".


-- 
Alexander Kuzmenkov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company


Attachment

pgsql-hackers by date:

Previous
From: Fabien COELHO
Date:
Subject: Re: Offline enabling/disabling of data checksums
Next
From: David Steele
Date:
Subject: Re: Add exclusive backup deprecation notes to documentation