Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gvWft-00056l-MJ for pgsql-hackers@arkaria.postgresql.org; Mon, 18 Feb 2019 00:20:46 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gvWfr-0000ZP-Ec for pgsql-hackers@arkaria.postgresql.org; Mon, 18 Feb 2019 00:20:43 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gvWfr-0000Yu-6I for pgsql-hackers@lists.postgresql.org; Mon, 18 Feb 2019 00:20:43 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gvWfo-0000vM-Ps for pgsql-hackers@lists.postgresql.org; Mon, 18 Feb 2019 00:20:42 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.4/8.14.4) with ESMTP id x1I0KP5G012718; Sun, 17 Feb 2019 19:20:25 -0500 From: Tom Lane To: Andres Freund cc: Antonin Houska , Aleksandr Parfenov , a.bykov@postgrespro.ru, pgsql-hackers@lists.postgresql.org Subject: Re: Optimze usage of immutable functions as relation In-reply-to: <20190216014332.ifjqaaew4tfvzpnk@alap3.anarazel.de> References: <402356c32eeb93d4fed01f66d6c7fe2d@postgrespro.ru> <20180906185109.661aaef0@asp437-ThinkPad-L380> <153994199621.10161.17815885396545049364.pgcf@coridan.postgresql.org> <11120.1541686083@localhost> <20190216014332.ifjqaaew4tfvzpnk@alap3.anarazel.de> Comments: In-reply-to Andres Freund message dated "Fri, 15 Feb 2019 17:43:32 -0800" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <12716.1550449225.1@sss.pgh.pa.us> Date: Sun, 17 Feb 2019 19:20:25 -0500 Message-ID: <12717.1550449225@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Andres Freund writes: > Given this I think the appropriate state of the CF entry would have been > waiting-for-author, not needs review. Or alternatively > returned-with-feedback or rejected. I'm a bit confused as to why the > patch was moved to the next CF twice? We have this review from Antonin, and mine in https://www.postgresql.org/message-id/2906.1542395026%40sss.pgh.pa.us and there's the cfbot report that the patch doesn't even apply anymore. 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'm going to go set this CF entry to waiting-for-author, but unless a rewritten patch appears soon, I think we should close it returned-with-feedback. I think the idea is potentially good, but as I said in my review, I don't like this implementation; it has the potential to be a net loss in some cases. regards, tom lane