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 1tnMOd-004ZXM-L4 for pgsql-hackers@arkaria.postgresql.org; Wed, 26 Feb 2025 18:44:39 +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 1tnMOc-00BOwc-GO for pgsql-hackers@arkaria.postgresql.org; Wed, 26 Feb 2025 18:44:38 +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 1tnMOc-00BOwU-6B for pgsql-hackers@lists.postgresql.org; Wed, 26 Feb 2025 18:44:38 +0000 Received: from mail-pl1-x62f.google.com ([2607:f8b0:4864:20::62f]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tnMOY-000EWK-2v for pgsql-hackers@lists.postgresql.org; Wed, 26 Feb 2025 18:44:37 +0000 Received: by mail-pl1-x62f.google.com with SMTP id d9443c01a7336-220c92c857aso3147085ad.0 for ; Wed, 26 Feb 2025 10:44:35 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=j-davis-com.20230601.gappssmtp.com; s=20230601; t=1740595475; x=1741200275; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:from:to:cc:subject :date:message-id:reply-to; bh=O8KxMeR7heITWZCbLLKv9O1LgviGdHN2tj2IDOChkw4=; b=fJvkp8LXdNumQ4Fale7myoNtnAFC336Ot5AZ8aOP0hqSf09me/mQfsdPVEJRkCMHED ESy5u5F9PlZ+rolidY8SVdS7MlUDaAcShNXG51kqedT5arp45dGdXftyp8iThOr7GdDC BVveXiflcG3wweggFj5JLgmlYdb6e6lMTzy/1j3Bx6TLlrbP5Ei/vtnrIeH9wl1F4njz Lv0K2BH1rssEZ0Nm4tVPyvZLGwYdB/8lWqWqq445jD0/EuTc4xQK1VBL1IfuNtTQ7a4M +2mNgEOTeLoGVpfntLjk0j91Nh7dNJDDJPZhVpSKCuJiSdwqqQjlU7aiMu1U4DsHdYNI TKQQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1740595475; x=1741200275; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=O8KxMeR7heITWZCbLLKv9O1LgviGdHN2tj2IDOChkw4=; b=VP4csBILSL5onINvjb0ajxeXr7c798UYsEkouZIwy5uAG1O3HvbQL37PKUFZs4oSVb 5VQCH0CIkR8gUvO4XFuWxQSXhNJDODnZAvBlpWdurz8YHgIgCIUcNhl6AygqI1CO/qZe s07EkFzEXaItqHMrb1gm49Zk+3SHij29kNR17tbImJOe87Zlow4nQqi7PJbR6d6Cgaub hHSFaKyAgD6OjC1/FFezz1q4UDAaq2a2y9TpBSruei23Az2pHPfwGqfs6KlZEVcD1i24 rcJrMPqozzBb5J+2+Li4sU5Tph2EkwyP6JqDMvj6ASbSbqs0/OHH+P1JaxMtP6yaxMZ9 ds2A== X-Forwarded-Encrypted: i=1; AJvYcCVQ0YUionqk0IqNpY7QOFtDNrUuCLxj975YLlFloQaJuCm2n80cw9zfaOBRv7p74e6KaAqQu2Cep2WIxDdQ@lists.postgresql.org X-Gm-Message-State: AOJu0Yw8EtjX1tOl4HAqfTWY9aJ6XFZL38VkYR9PJeE7dREm/4u7XTGi q+7cY7yVPMbOT2GeX1M8iBGGqPOjXiQtpJGiWvT/miqmcEpE1gqXEh6sTXi+gg== X-Gm-Gg: ASbGncuRQvE7USJNmQBG/FG6mCgXR/D/DiiV0U2WESwfydavVOgdAnK1LXJZtT3Q2pB mVUvlmD3KtWprJafAp5MFSRBFeQ5vDlvy0yxYenDbVg5Glg+vUtzOKr0WEiXMSBS91vSsihXi/T +utf1nTfr/pX94xgeVM+ZYMBvdvV1IY/QiVNw85Qe2wIgDa+Tpw7ZhC04Ba4QhCzd4raRa315PL tH4ugUyWWvGQkwKRoA2HYv61+YR9dU5bpC1873oxIaXuuZM6GCKPu9ivKzcNU8V0apxbVOVd6uC RszxZEU1M8zFQGg9hWMV5snG/PHy8JXMLtJIQvwIwFDQr+xmWj0+w7C3qTInwe6YrVEb X-Google-Smtp-Source: AGHT+IEM4/zcA/INyLs+NP0HM/Ra6NtKkbNTrBFQ3NUo7Lj6gtVMrMjOSwY8zE3yGstJZg67x7UFjA== X-Received: by 2002:a17:902:f70a:b0:223:4d5e:76a6 with SMTP id d9443c01a7336-2234d5e77c9mr962395ad.1.1740595474898; Wed, 26 Feb 2025 10:44:34 -0800 (PST) Received: from jeff-laptop.lan (c-76-102-242-158.hsd1.ca.comcast.net. [76.102.242.158]) by smtp.gmail.com with ESMTPSA id d9443c01a7336-2230a092d39sm36256325ad.149.2025.02.26.10.44.33 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 26 Feb 2025 10:44:34 -0800 (PST) Message-ID: Subject: Re: Statistics Import and Export From: Jeff Davis To: Tom Lane Cc: Corey Huinker , 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 Date: Wed, 26 Feb 2025 10:44:33 -0800 In-Reply-To: <1891219.1740593186@sss.pgh.pa.us> References: <3670503.1740173078@sss.pgh.pa.us> <3728741.1740178078@sss.pgh.pa.us> <97b451228227c555be1a4f79c4a62ddec9a74f06.camel@j-davis.com> <6af48508a32499a8be3398cafffd29fb6188c44b.camel@j-davis.com> <1698502.1740541206@sss.pgh.pa.us> <1704472.1740544569@sss.pgh.pa.us> <1707557.1740546344@sss.pgh.pa.us> <51fca6b6c0032d28e053ad89f7e858e2a9e498af.camel@j-davis.com> <1891219.1740593186@sss.pgh.pa.us> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.44.4-0ubuntu2 MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, 2025-02-26 at 13:06 -0500, Tom Lane wrote: > Jeff Davis writes: > > I ran a quick measurement and it appears within the noise of the > > numbers I posted here: > > https://www.postgresql.org/message-id/6af48508a32499a8be3398cafffd29fb6= 188c44b.camel@j-davis.com >=20 > Thanks for doing that.=C2=A0 I agree with your other comments and > will incorporate them. Also, here are the numbers with an optimized build: --no-statistics: 0.21 s pre-optimization (6c349d83b6): 0.75 v3j-0001 (8f427187db): 0.65 v3j-0002 (6ee3b91bad): 0.27 new patch 0001+0002: 0.26 Regards, Jeff Davis