Horton

Re: Optimze usage of immutable functions as relation

Alexander Kuzmenkov <a.kuzmenkov@postgrespro.ru>

View thread View on postgr.es
From: Alexander Kuzmenkov <a.kuzmenkov@postgrespro.ru>
To: Tom Lane <tgl@sss.pgh.pa.us>, Andres Freund <andres@anarazel.de>
Cc: Antonin Houska <ah@cybertec.at>, Aleksandr Parfenov <asp437@gmail.com>, a.bykov@postgrespro.ru, pgsql-hackers@lists.postgresql.org
Date: 2019-02-28T14:27:51Z
Lists: pgsql-hackers 
On 2/18/19 03:20, Tom Lane wrote:
> The dummy-relation stuff I referred to has now been merged, so there's
> really no good reason not to revise the patch along that line.


I'll try to post the revised implementation soon.


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

Commits

  1. Prevent bogus pullup of constant-valued functions returning composite.

  2. Allow functions-in-FROM to be pulled up if they reduce to constants.