Re: WIP Patch: Precalculate stable functions, infrastructure v1 - Mailing list pgsql-hackers

From Marina Polyakova
Subject Re: WIP Patch: Precalculate stable functions, infrastructure v1
Date
Msg-id eab78416e49e9024c04b6c4fb49cd5b7@postgrespro.ru
Whole thread Raw
In response to Re: WIP Patch: Precalculate stable functions, infrastructure v1  (Andres Freund <andres@anarazel.de>)
Responses Re: WIP Patch: Precalculate stable functions, infrastructure v1
List pgsql-hackers
Hello!

On 24-01-2018 23:36, Andres Freund wrote:
> On 2018-01-24 15:10:56 -0500, Tom Lane wrote:
> ...
>> Keeping the stored value of a CachedExpr in a Param slot is an
>> interesting idea indeed.
> 
> We keep coming back to this, IIRC we had a pretty similar discussion
> around redesigning caseValue_datum/isNull domainValue_datum/isNull to 
> be
> less ugly. There also was
> https://www.postgresql.org/message-id/20171116182208.kcvf75nfaldv36uh@alap3.anarazel.de
> where we discussed using something similar to PARAM_EXEC Param nodes to
> allow inlining of volatile functions.
> 
> ISTM, there might be some value to consider all of them in the design 
> of
> the new mechanism.

Thank you both very much for this discussion and for the link on that 
thread! Now I'm working on the patch, thanks to Tom Lane's comments 
earlier [1], and I'll try to implement something of this..

[1] 
https://www.postgresql.org/message-id/403e0ae329c6868b3f3467eac92cc04d%40postgrespro.ru

-- 
Marina Polyakova
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company


pgsql-hackers by date:

Previous
From: "Tsunakawa, Takayuki"
Date:
Subject: RE: Temporary tables prevent autovacuum, leading to XID wraparound
Next
From: Abinaya k
Date:
Subject: Re: Regarding ambulkdelete, amvacuumcleanup index methods