Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tn8HR-002RDO-AH for pgsql-hackers@arkaria.postgresql.org; Wed, 26 Feb 2025 03:40:17 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tn8HP-00DwXu-Ri for pgsql-hackers@arkaria.postgresql.org; Wed, 26 Feb 2025 03:40:15 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tn8HP-00DwXm-Hg for pgsql-hackers@lists.postgresql.org; Wed, 26 Feb 2025 03:40:15 +0000 Received: from sss.pgh.pa.us ([68.162.161.243]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1tn8HM-000707-16 for pgsql-hackers@lists.postgresql.org; Wed, 26 Feb 2025 03:40:14 +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 51Q3e6rW1698503; Tue, 25 Feb 2025 22:40:06 -0500 From: Tom Lane To: Corey Huinker cc: Jeff Davis , Andres Freund , Michael Paquier , jian he , Nathan Bossart , Bruce Momjian , Matthias van de Meent , Magnus Hagander , Stephen Frost , Ashutosh Bapat , Peter Smith , PostgreSQL Hackers , alvherre@alvh.no-ip.org Subject: Re: Statistics Import and Export In-reply-to: References: <3670503.1740173078@sss.pgh.pa.us> <3728741.1740178078@sss.pgh.pa.us> <97b451228227c555be1a4f79c4a62ddec9a74f06.camel@j-davis.com> <6af48508a32499a8be3398cafffd29fb6188c44b.camel@j-davis.com> Comments: In-reply-to Corey Huinker message dated "Tue, 25 Feb 2025 21:29:56 -0500" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <1698501.1740541206.1@sss.pgh.pa.us> Date: Tue, 25 Feb 2025 22:40:06 -0500 Message-ID: <1698502.1740541206@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Corey Huinker writes: > We can still convert the "EXECUTE getAttributeStats" call to a Params call, > but that involves creating an ExecuteSqlQueryParams(), which starts to > snowball in the changes required. Yeah, let's leave that for some other day. It's not really apparent that it'd buy us much performance-wise, though maybe the code would net out cleaner. To my mind the next task is to get the buildfarm green again by fixing the expression-index-stats problem. I can have a go at that once Jeff pushes these patches, unless one of you are already on it? regards, tom lane