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.96) (envelope-from ) id 1vN42s-00A60g-0U for pgsql-hackers@arkaria.postgresql.org; Sun, 23 Nov 2025 06:58:02 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vN42q-00Dmdf-1L for pgsql-hackers@arkaria.postgresql.org; Sun, 23 Nov 2025 06:58:00 +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.96) (envelope-from ) id 1vN42p-00DmdX-1B for pgsql-hackers@lists.postgresql.org; Sun, 23 Nov 2025 06:58:00 +0000 Received: from fout-a7-smtp.messagingengine.com ([103.168.172.150]) by makus.postgresql.org with smtp (Exim 4.96) (envelope-from ) id 1vN42n-000zUw-0Y for pgsql-hackers@lists.postgresql.org; Sun, 23 Nov 2025 06:57:58 +0000 Received: from phl-compute-06.internal (phl-compute-06.internal [10.202.2.46]) by mailfout.phl.internal (Postfix) with ESMTP id DC0EBEC00C5; Sun, 23 Nov 2025 01:57:56 -0500 (EST) Received: from phl-mailfrontend-02 ([10.202.2.163]) by phl-compute-06.internal (MEProxy); Sun, 23 Nov 2025 01:57:56 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= cc:cc:content-type:content-type:date:date:from:from:in-reply-to :in-reply-to:message-id:mime-version:references:reply-to:subject :subject:to:to; s=fm3; t=1763881076; x=1763967476; bh=ziZLhA4Grz 74OK148uZdKMx8PRJ82pMw146JNxOxQmA=; b=L9flENxAxDQbrurc5V1GLoNceN 3snpEcYwTBKWT0aZgH07oxU3+GlPhjXuHiROprFw9wM1cwqh1ULhIUABYzBZXMMV Bj5uWstAhKjVvx4B6GkbPSr5i/TGfvoKL5ZbhjXXmTxGopyUAmAs/5sf+dSla8dV 8aD8daTrLZm/ZuQMgasgRDKHxOrcbQWbpNxHLHMFvVPH3ewVCqRxMa6b4CMiENuV VavY1GmG8df9LHyBwUX160798BizKTszg5AGaqmPmfMQkB2f5gVknRLRCtLH/WcX N7XEdsP3g9Gn3oFqL497wijKQmQ5GbDO11wHICR/ap+nCwpNF5kHeBlkWlXA== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-type:content-type:date:date :feedback-id:feedback-id:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:subject:subject:to :to:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm3; t= 1763881076; x=1763967476; bh=ziZLhA4Grz74OK148uZdKMx8PRJ82pMw146 JNxOxQmA=; b=YeHNWGBf3XZ2i86BGiOPhpeQz2PixlHsnYslTZgjl/oNCgi1tvm BfK1ee3JI3mXucom2CRbNslWku1yh50vBOS3S5lOQamgKWGCw6KznRd/MWS8aufW q1M2MzBeCAaIZt548XSWuTWL3fqs5vfJXI7p3lDk/alTcRXlofiRWrnz3dbApE8p z6vdnYpszs+6HwDJca/uxZ2UDOuAvugQQx19C+7H9sus3GO5zMSNe+zFFtC9OiiT hOF0aqT+rEQCWhzDnXDdUimNgj6QYl3FJfvaRMUIs7RMXjqxc1bw4GVCb52Mo2sg zAyvKodZ6g8Jxu48i/440gArafQ8W6f8dvw== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeeffedrtdeggddvfeehtdeiucetufdoteggodetrf dotffvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfurfetoffkrfgpnffqhgenuceu rghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmnegfrh hlucfvnfffucdljedtmdenucfjughrpeffhffvvefukfhfgggtuggjsehgtderredttddv necuhfhrohhmpefoihgthhgrvghlucfrrghquhhivghruceomhhitghhrggvlhesphgrqh huihgvrhdrgiihiieqnecuggftrfgrthhtvghrnhepteelieefudffhffhtdetleeggeeg fffhkeeuveetiefgudduvedutefggeeivdejnecuvehluhhsthgvrhfuihiivgeptdenuc frrghrrghmpehmrghilhhfrhhomhepmhhitghhrggvlhesphgrqhhuihgvrhdrgiihiidp nhgspghrtghpthhtohephedpmhhouggvpehsmhhtphhouhhtpdhrtghpthhtoheptghorh gvhidrhhhuihhnkhgvrhesghhmrghilhdrtghomhdprhgtphhtthhopehjihgrnhdruhhn ihhvvghrshgrlhhithihsehgmhgrihhlrdgtohhmpdhrtghpthhtohepthhomhgrshesvh honhgurhgrrdhmvgdprhgtphhtthhopehpghhsqhhlqdhhrggtkhgvrhhssehlihhsthhs rdhpohhsthhgrhgvshhqlhdrohhrghdprhgtphhtthhopehtghhlsehsshhsrdhpghhhrd hprgdruhhs X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Sun, 23 Nov 2025 01:57:53 -0500 (EST) Date: Sun, 23 Nov 2025 15:57:31 +0900 From: Michael Paquier To: Corey Huinker Cc: jian he , Tomas Vondra , pgsql-hackers@lists.postgresql.org, tgl@sss.pgh.pa.us Subject: Re: Extended Statistics set/restore/clear functions. Message-ID: References: MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="Xg5dpgeMDPnGA/sN" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --Xg5dpgeMDPnGA/sN Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Sat, Nov 22, 2025 at 03:26:19AM -0500, Corey Huinker wrote: > I'm open to it, but there was significant pushback to having tight validi= ty > checks on other stats types. Yeah, I am not sure that there is much value in having strict checks for the values. Some control over the arguments listed in a single object is much more valuable as these are easy to check in the input functions.=20 > The more things that we make errors, the more chances we have to breaking= a > dump/restore. Granted, such values should never happen, but odd things do > happen. Indeed. Like the existing import functions, these should not lead to hard failures, but WARNING-level reports. -- Michael --Xg5dpgeMDPnGA/sN Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmkisFsACgkQnvQgOdby QH2nxA/9FDj5Mo0ALHrUBQ6EOe6wSboXtSCXBfb+oyqs+0zUaFPunyI54Pt7hdOK M3dOSz4oFm2Htcn38sbJjXkgtIIP+79v5nGE4hetpOpvsCflrQ+iboOn5JJAjkec Mznj5a8G1bH368SWk9004pxtuj5Rv6r/Y6TfhFnReYZID28dET0EYusR3ykSDTqW p8I7iO6F6rWPSbebsKhpSIPAurSTzB2iAFA3HWDvBfFMi/45xaaWk8NdbWIs9azy xgCJWm9+gkVcpraNd8GawAP7WuSDRscAOsExf9ldRtsYYVtkQN0zZwrgSN83/g4u 7GJbeVykSz+R0oeb+E69a+t348Kgl3CIADjszbJVA6eD/uI5wbr3ZSxEza9Ehft0 rREclHFD3Ra55p+56bgcy86s0nZYd4hgbXE58oa6K3JUfZqzzBmhatvYtrldy6er vefP3MY7Y3B4zi5fbC6FSsKFnYj7AEKbdjfdQE4YtZRzmY1YveYYwhsgVtibntXd mrKqyvU3yM2BugnwbGdQ936J97ZyMbId/Xewz79A7quDtls238v9gXfFs7TJnLWf 2Y9Gs3Egj136aHxMRJFhhga6EuVEBGw5zCCeyTdoKs7Q1IUWk3q9gNdB045Y6exi S57z3z3buyTCSaJA8wC0Q3lRjMivJ/a3nOZKn81Ed1SUGlZjmFA= =GJzt -----END PGP SIGNATURE----- --Xg5dpgeMDPnGA/sN--