Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oAg6o-0003Zn-CR for pgsql-hackers@arkaria.postgresql.org; Sun, 10 Jul 2022 23:13:02 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oAg6n-0001eZ-8l for pgsql-hackers@arkaria.postgresql.org; Sun, 10 Jul 2022 23:13:01 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oAg6n-0001eQ-06 for pgsql-hackers@lists.postgresql.org; Sun, 10 Jul 2022 23:13:01 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oAg6g-0000NP-K5 for pgsql-hackers@lists.postgresql.org; Sun, 10 Jul 2022 23:12:59 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 26ANCqtR816653; Sun, 10 Jul 2022 19:12:52 -0400 From: Tom Lane To: Andres Freund cc: pgsql-hackers@lists.postgresql.org, Peter Eisentraut Subject: Re: Extending outfuncs support to utility statements In-reply-to: <20220710214348.b63jkf3ko5tkeldz@awork3.anarazel.de> References: <4159834.1657405226@sss.pgh.pa.us> <20220710214348.b63jkf3ko5tkeldz@awork3.anarazel.de> Comments: In-reply-to Andres Freund message dated "Sun, 10 Jul 2022 14:43:48 -0700" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <816651.1657494772.1@sss.pgh.pa.us> Content-Transfer-Encoding: quoted-printable Date: Sun, 10 Jul 2022 19:12:52 -0400 Message-ID: <816652.1657494772@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Andres Freund writes: > On 2022-07-09 18:20:26 -0400, Tom Lane wrote: >> For my taste, the circa 20K growth in outfuncs.o is an okay >> price for being able to inspect utility statements more easily. >> However, I'm less thrilled with the 30K growth in readfuncs.o, >> because I can't see that we'd get any direct benefit from that. >> So I think a realistic proposal is to enable outfuncs support >> but keep readfuncs disabled. > Another approach could be to mark those paths as "cold", so they are pla= ced > further away, reducing / removing potential overhead due to higher iTLB = misses > etc. 30K of disk space isn't worth worrying about. They're not so much "cold" as "dead", so I don't see the point of having them at all. If we ever start allowing utility commands (besides NOTIFY) in stored rules, we'd need readfuncs support then ... but at least in the short run I don't see that happening. regards, tom lane