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.98.2) (envelope-from ) id 1xRN4v-00000000ue1-2QQX for pgsql-bugs@arkaria.postgresql.org; Thu, 12 Nov 2026 05:10:29 +0000 Received: from localhost ([127.0.0.1]:53350 helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.98.2) (envelope-from ) id 1xRN4u-0000000EyTz-1ncQ for pgsql-bugs@arkaria.postgresql.org; Thu, 12 Nov 2026 05:10:28 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]:42142) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xRN4u-0000000EyTr-0gLH for pgsql-bugs@lists.postgresql.org; Thu, 12 Nov 2026 05:10:28 +0000 Received: from fout-b7-smtp.messagingengine.com ([202.12.124.150]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xRN4r-00000000abZ-2qBY for pgsql-bugs@lists.postgresql.org; Thu, 12 Nov 2026 05:10:27 +0000 Received: from phl-compute-11.internal (phl-compute-11.internal [10.202.2.51]) by mailfout.stl.internal (Postfix) with ESMTP id 47CFF1D00213 for ; Thu, 12 Nov 2026 00:10:23 -0500 (EST) Received: from phl-frontend-03 ([10.202.2.162]) by phl-compute-11.internal (MEProxy); Thu, 12 Nov 2026 00:10:23 -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=1794460222; x=1794546622; bh=Vf4utEXcTB 5Rtb+kh3src+nn4j6K0ThRCMv8srHVk6U=; b=D5ZMmm1p41p3xmFkrTJrnNhhWt N78ZGg8LG5qDl8O/P/xXjGx/xxlLuxiWl3RkqF+/rUfZvIo6i+ZfCyECfoONLvdL BseFicOWbTIVBDkW2ZwtjXJ0REBaiE6TX1zuKG+CyYE5ovwQ79b7KF4GY/V0EEhV DM9z+XqALZ2Z2BkbKXOeqBCu06kAxWPkXG9t1/Aoc9/5FPKPSeOCNaSwqG/2jR4O jKKZkE1I4O8xbTSrLdlqyNckRt6lRJi27iQl1JJlmFCc25u6ryhKHcFpPzWs4/zh IYIMumPacbcIbvzx9+BmdwiKywT6v/LmlDhT8VGdQhzgFtchik782BxjGXBA== 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= 1794460222; x=1794546622; bh=Vf4utEXcTB5Rtb+kh3src+nn4j6K0ThRCMv 8srHVk6U=; b=osdsg6yBRkrNfRv5taLJSVUUztpxtLqUIAJuePLcG1ST7KPSCKx NDpe7mcfVCcQCOdOnDktdpABBR5u4AuKybxAlhGia5DpuaYvRSNu7BhJX7jIZDRF R0UPv1ZAm1KYEnrveZQFDH5D/UA1ykM/QNV9YSI1j1jS8F+jth2aJtdKD0HSYxkM XbpILxdFO54iCRUjOvl7b161ooFx3d2/PQ/gJli34m5tSOVg9M5OnSTWSab6HnNo E5+2qo4xCBfD+GFvFm6mB8Umn4MXvTSnx6m8XEVNik/rplIwS9U3CT4deharosUm Bt0FWr5EU5HHqhL4o2bN0/0e4BgjdtFBniw== X-DKIM2-Info: draft=ietf-dkim-dkim2-spec-09; repo=github.com/dkim2wg/interop; date=2026-11-03; sw=lmtpprox; action=sign d=paquier.xyz a=rsa-sha256; DKIM2-Signature: i=1; m=1; t=1794460222; d=paquier.xyz; mf=PG1pY2hhZWxAcGFxdWllci54eXo+; rt=PHBnc3FsLWJ1Z3NAbGlzdHMucG9zdGdyZXNxbC5vcmc+; s=fm3:rsa-sha256:U/Tf10V2psmVuPwf2PX0+ezDSFAxJbPL66zr2iVgpsN9tnV 0gIiqi+QT2q+0fILkf5qYqQBSeztfbzZ1ZuYDF5abqN0ksmZnca4QOrDC7NDGpPd FZZUMVszGA79oQ8ZnRDxVYSrGcBSCDyZaCIc1XuG0QCRdNBZ4rWWA8k1r/9g2Vu8 vYiUOFvK1D1csrJKrK8PhgUNeU1tnrnn5GerCTRnDhWK0JsJXHpynqLxifEse6ZI JXQ4h11qQV8v8jbEVREhT/YDsoVTk5ATeDsj0eTdq1JV8xBARCKkJb6juueLwzWW r++itWqht7Okloa84zkMvBiygZlLrFdpq8k5vHQ==; X-DKIM2-Info: draft=ietf-dkim-dkim2-spec-09; repo=github.com/dkim2wg/interop; date=2026-11-03; sw=lmtpprox; action=mi-m=1; hc=12; hn=cc,content-disposition,content-type,date,feedback-id,from, in-reply-to,message-id,mime-version,references,subject,to; Message-Instance: m=1; h=sha256:mKJWGU2dSzxvDIOhcLYliOWxXD8FcHJvILThpbbUUGA=:u+DMR4HpJzBasS11LaY9T0Lhz7vF3gWAYNNU0muNw9g=; X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: dmFkZTF4RtGtW3oJQCAOoJrMVFwhXojOgQeHM/SwFXrGgCeJrpjG839qVHI/9SwLrMTCGq yHtkjgBuRYrTp3Xs+lrpg86iios0IUHTLlnk87WtK9s6eroYKzecSic79MSWxxQwiJi+KI deRDw0GW560mFW4ZAR29+gZP8vM7/ocditsma/0Qa56xx/+6v7Faet9qtV2uv6dssMmExY phaOW/XRONeb0PWFrp7N38cTlnLp42pLIXWnHPrMpVCgcV55+J1TfRqgVXJutntyVF+ro9 pr/InErAel70gtZr71/UtNwG6FIRe5PXcPejjEmvlbHHBh0KXd9AAKa77PPvP+nO3aHsb1 Nw1QntR63PFC8iWBt38neKSna1iV5Q7q/UgbIlzgDKta7BsR4gjKG5UxPkWqjbuRzAYbQJ qx4V42/Y/yXooZHrB85wO1cDNuSLks3QZZQhrUh8bS3dWtRmPFnSByPpF4C30bwFPyg+sG JsY8vB3CjxG3mHUcPMocVwDqnuNSpx7u/n9IjP/kiTqouRqfFINdtbostcNwLURBTQX2y8 1DXsAD0b0I2fCJsBxi+g6Iqe30PR8dULcolEt00G34F88U+tlLDDbgdGPZWkSkKHQt1CME bn3wtbpQhGLuSIZ6D9rz64VmjGWpBuwauUEztRrCiXoNfZ37AIa6dMiBwysw X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Thu, 12 Nov 2026 00:10:21 -0500 (EST) Date: Thu, 12 Nov 2026 14:10:19 +0900 From: Michael Paquier To: Corey Huinker Cc: pgsql-bugs@lists.postgresql.org, 125atishprak@gmail.com Subject: Re: BUG #19857: Stats restore rejects empty arrays, losing range and array stats Message-ID: References: MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="TrzeWHUoQySDa0OW" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --TrzeWHUoQySDa0OW Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Wed, Nov 11, 2026 at 11:55:08PM -0500, Corey Huinker wrote: > But the problem still exists on 18, and that isn't a clean backport. > Michael, do you want me to take that one? The only problem that can be reached is if we dump or upgrade from a v17 or v18 instance with the pattern of a range_empty_frac set with range_length_histogram as NULL, where we could perhaps switch range_length_histogram to '{}' under-the-hood on the dump side if a range_empty_frac exists. I don't want the restore functions to live eternally with a path authorizing for range_length_histogram=NULL if there is a range_empty_frac, especially now that range_length_histogram has to be an empty array since v19~. And the end, I have no plans to bother based on the table definition this requires. I could still care with something on the dump side, but I doubt that's worth the effort anyway. What's been done on HEAD and v19 is enough for these new empty-array cases. :) -- Michael --TrzeWHUoQySDa0OW Content-Type: application/pgp-signature; name=signature.asc -----BEGIN PGP SIGNATURE----- iQIzBAEBCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmr1SjsACgkQnvQgOdby QH1fxQ//TiQI+8F69xKLi86JhwEA1d6S6AG+92RWoKiLIv2mhHmStYXVZxN0IXD/ IIBHEWpHGzfsFG3zPUUEXYg6ueQD10GbzcDp82nUAr5qF4sf+4tygBYC7XoveKfB 3gtfInjY8naaZtN9hQ50RrfoAaV9jhsuGjpfEMtmeKLcYQX4k2RmO8UCk9/lX/+C aBeLWCeiLoHJi9osjOi0oNLDdTuK2ULj6OdLtBEwJTXyQXZMyhUNR+sPQB6/p5Ex +L3xv/bLQKDMtLJ2l8W9+2tP916Pv6fi3BQTFhg9jRyi7/duqfzyN3ZpLjnGq3K/ 2kJwcsBgdMgMG4/zzIPTdHHqncMaehefRwDVWsNI/DERm7RviwroquzycsVWgsSO 9cEuTiuRdmfA5DaQa4D8bwsm3APY/G+r3LLuVLxNMOPhNMWBQcrzY29noMysp0vk fxA6EwbPsC9lq5EVIHUmrflFyKjWMvgDffkmnlMQ5g2vS0smhsGDHvjd4IxrW/cx Mn9F5TDc0KIiTCh9kxhgmXULreoUQ4ONO5FjBzxlHrs9Mj3n1DskiqANUw2ssT5U esmHSAig090ix8dI6y1aRCeIdY8eRkNTKf2MNnDjAhT8lQj+Me9h9XTHEl9UQQ+d xyIDpIZrIRdoBsl8l2pU5JTO8yZvtTiJ7LyL58hws8f10CTQa+U= =KNBU -----END PGP SIGNATURE----- --TrzeWHUoQySDa0OW--