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 1xR1vI-00000000c6N-2qgy for pgsql-bugs@arkaria.postgresql.org; Wed, 11 Nov 2026 06:35:09 +0000 Received: from localhost ([127.0.0.1]:57250 helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.98.2) (envelope-from ) id 1xR1vG-000000091qi-3kOv for pgsql-bugs@arkaria.postgresql.org; Wed, 11 Nov 2026 06:35:07 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]:58632) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xR1vG-000000091qa-1KTI for pgsql-bugs@lists.postgresql.org; Wed, 11 Nov 2026 06:35:06 +0000 Received: from fhigh-a2-smtp.messagingengine.com ([103.168.172.153]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xR1vE-00000000KGU-2tn5 for pgsql-bugs@lists.postgresql.org; Wed, 11 Nov 2026 06:35:05 +0000 Received: from phl-compute-03.internal (phl-compute-03.internal [10.202.2.43]) by mailfhigh.phl.internal (Postfix) with ESMTP id E670A1400152 for ; Wed, 11 Nov 2026 01:35:02 -0500 (EST) Received: from phl-frontend-04 ([10.202.2.163]) by phl-compute-03.internal (MEProxy); Wed, 11 Nov 2026 01:35:02 -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=1794378902; x=1794465302; bh=VFm3HSaYYq 3WCrE67fJAztdoLYlYTC2UnSWbBmtJFhs=; b=TlIqAvqOCs/ydO9fkJpwgZzh/e CYK+YW/1xvl/qxCv+tH1pVz+6RVbublT1jIXC/XNZQlKwqnlTsvfBtj5zExg9vpt T5+iatXWsTnp6/A9Ywrj3G4OLoXV0EgyFrT/eCC4Vrz9RdVDkqI1DXr3XXuYFvSO 0JlSomX4hsb/DBCwxJaZoUYU0ITKW31lbMvkjP0XiWgs7K6mjyVEIOtSUPkLxiUu dcTDcGsp/+dpFnFpm9H/4YnJLF8gJez/5p+ey3sCQPw8ntkKnntbhHGfRnvKvCAz rucZvK/nIAI2FZQNqycRlg+djrafcMNUIX6gobUG9FmJcnV5aBe4KvlydNUw== 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= 1794378902; x=1794465302; bh=VFm3HSaYYq3WCrE67fJAztdoLYlYTC2UnSW bBmtJFhs=; b=xHnk/R0oaIlrf4MeBzJ74OAr65Bxx8ImclxmpKKfrPjZDY73hnj gp1WWOEFomQtXTQmEoaG2cCvvLUfGzfq51jw8Ef8yCe7CTrrzBB6PJUCA+OqUArl i0tPUgw8ljkfr07OuFBC1/AFprwoDRLODlEVa9WBi1g7bCcP6HJEMA5UQ1MtM7HS 9o6iqpRNz8HQZSOyvRTKD81+B7O09lYw61MiMaWw8Ev4RSrH26gJXTqazNn+XCyL XDQ5G69tfNc/V9rVFyDZgQAgmDeoZLST3GgFffV9gUuuqLRaq1OeGsaKnRMx3lq+ smQKhu+tifgev4VHl1Vtxt2j8hfiB3VSUGw== 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=1794378902; d=paquier.xyz; mf=PG1pY2hhZWxAcGFxdWllci54eXo+; rt=PHBnc3FsLWJ1Z3NAbGlzdHMucG9zdGdyZXNxbC5vcmc+; s=fm3:rsa-sha256:S6YN1HFndpkP9So1PVgBOIZeb5bU62kwSNEmFOQIWc7BLeb mvkkQGHci54Qsf8KHRWQ883zC8EbcApI7cDQKUx9+ir6dy4CtHqc9kVmP/fZphQV YPvNQ6Gi+sPbGTXgU4cg+7CAg373d55/lwodS6jk28aSD/k15ACdypUF9ViDPLeR Asj5zhA+ccLojt3JCKAZmzNkJfw2Ql7LrNgGQXMlVWTjvi0qrpBl+5GECPSSz1rm rqO911iQ1E4vlYtLvgFo43a+kF4D6GjbRWN+S1zWl2vqqauQNqjHaChqo9D7sGx1 LcdU3YikqTKxZYOS9XLWp4GKr1AzuC4O1VPNZ3w==; 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:AKOJoh4j40QiF6uGYQSphvLFh9fi6SNk/QpF4n6S9lc=:w+V6RyL+LQDNrV2uZHmvSjhHzr5lXydvF06FkZvffvU=; X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: dmFkZTFwfwC9HCXKSdL2k3Y0F+EBImOQdRBvmZM7AkNZsnU6jTnFTDLZf6Coz2zFCDL1Rm l4WDFgFIN+e2Dkq1PrgldjN16alH/xLtUMglPuw+pQ/Zcs9hQiYA4PGnO6GFfW8aGLc1ep 8k6iaXkdtjrB5UR8cCwTu4Vi8ClzWYcs1A3G8ogK9hnVWlAEya0MiE3UWzsmHhBqV1AwBW cfSv9N+Vffq3xiierj+fZXcNdze5IIHBfjZlbe6VINxWAYR0Xs0uQQhgP0v/hGMEhr3Y8O /naYUgVCONWVMeC1BcLLLn0zz4yP6m+LPEZXXUpFOpSBqdjmxmn5i9GfdPCxs9tnD32SFN H0IXb1XxHdgfEqIjn3yAQ04lMJ3E5j95DedwObMvb/h83kU1nzIKtX+W/XqZR414np0b3j ywnf76QCtZAiYNbLjnLdE/OQcmbTa/cdWelgtduSP6YasrvgLC0j1/AFnlBP0EL6erCgw6 bVdPWijis8aAcfwJnnGITjYqr+vt/52jLieJZuCUAnweEnKjxQuq239runGV8lykzvke3r 0ayYI/ZYvi4JubHGUN8t4lRaG0koZ48h3Kij7plc/ABbj0CTPouVK5QMxaJlJFExXA4BnD fwmMGWZgTJ5xhzmEn+h73RDruDPhn5ynkmGv+7fcgWKPmGO/YSJzL2CogoKA X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Wed, 11 Nov 2026 01:35:00 -0500 (EST) Date: Wed, 11 Nov 2026 15:34:57 +0900 From: Michael Paquier To: Corey Huinker Cc: 303677365@qq.com, pgsql-bugs@lists.postgresql.org Subject: Re: BUG #19842: pg_restore_extended_stats() rejects a faithful pg_dump of ANALYZE-produced range expression statisti Message-ID: References: <19842-ca042326dd2430a4@postgresql.org> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="Bby6I7lB3+qQtn39" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --Bby6I7lB3+qQtn39 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Tue, Nov 10, 2026 at 08:54:33PM -0500, Corey Huinker wrote: > This bug has the same root cause as bug #19857, but because that one deals > exclusively with attribute stats it needs to be backported to 18 as well, > so I kept that separate. >=20 > 0001 - Same bugfix proposed for #19587 > 0002 - Decoupling range_bounds_histogram from checks against > range_length_histogram and range_empty_frac > 0003 - The extended stats equivalent of 0001 Let's do things in order, and discuss about 0001 first. And I have a few things to say about it.. But let's see that on the other thread. -- Michael --Bby6I7lB3+qQtn39 Content-Type: application/pgp-signature; name=signature.asc -----BEGIN PGP SIGNATURE----- iQIzBAEBCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmr0DJEACgkQnvQgOdby QH11XA//ZwNXbZrahA+MXL0L/HyjqUG2EbaD8OzaknuBphmC0L7X8LnG85UdJLNw lmo/jWgqes7bKA+GqpLKm7RHN/38EjyaZaR1ns2JiniXEQnW1FCJHkT9ZjZagBTK RH2l293mzozYpPKSnTW7nMCIgCp77BTmhq6L4yHpVDPdh+ehmeJZ2RTpbPTrAKSM hlzuasn4c2OLEiB8PP2hDfdC4TXBSlo6mADtLw7Q0MlpuPMd5hOQL/i+FhcJ687n jY57X7cHUCYNG+Ox6Pz0bvqCWf8vpK1T3N5LkrxfMFfIwo/hQmRhmIb9cOoQh00E /T4gsGBxyVKhB1+MRqvhX/qsq75o2T4hG+sQRRKJvJRnWtIB7WcJj3jEoRyNTI0C b/odoM/17VCaUJJrl4QbQqttAq7TxBpjJ1KSTdvJIEluUt7fcn42pDfukI9e72Dr +73hctzikTvHRV/Q87RYfl8CMspZzTZWiEpKSKg+DI4o/a7z37RbLioW//YjNxIh W1etNkOTmYMUHnX1o/81s7pXag25jBd5udd6HyiWuikRFbGddzoCRtqq3+GTbkwg LTU1LBtoQwnVRsHGonuHuhUauOpqD3JXy+S/elPXPVci/X+nz0FXaA9NNUxrT/hw UPcv3CBgSCFtE/iDTUZpxY3Xmiyno21JjwC+AgAWBL8CORy7Cxg= =Gf1/ -----END PGP SIGNATURE----- --Bby6I7lB3+qQtn39--