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 1trmwa-009TIw-Dw for pgsql-hackers@arkaria.postgresql.org; Mon, 10 Mar 2025 23:54:00 +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 1trmwY-002hHN-Fj for pgsql-hackers@arkaria.postgresql.org; Mon, 10 Mar 2025 23:53:58 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1trmwY-002hHE-2X for pgsql-hackers@lists.postgresql.org; Mon, 10 Mar 2025 23:53:58 +0000 Received: from mail-pl1-x62b.google.com ([2607:f8b0:4864:20::62b]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1trmwT-0028AH-38 for pgsql-hackers@lists.postgresql.org; Mon, 10 Mar 2025 23:53:57 +0000 Received: by mail-pl1-x62b.google.com with SMTP id d9443c01a7336-225477548e1so42888265ad.0 for ; Mon, 10 Mar 2025 16:53:55 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=j-davis-com.20230601.gappssmtp.com; s=20230601; t=1741650833; x=1742255633; 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=++7pLyQ7UqPjDZ/zpi0EqmxvFy2RKpveJLK15H2O0Mw=; b=LK1OkofHLQvFf2pp3DEmPCI4qwFp9FXIYaeJZKG2S/+wAkPtjmxT+jT6TXkYh3NvXt KVt2iltVRLoC01JK8bi7inWZlQwgR5B0IiYonQFLErkQg+rgOieDBG1PO8VAxO+vcoLZ IIaExVuXJa3LLZM+jDxQ7LF9as5SjVq2lwRxgF8WyK0ehAHHuwUo+GuMSOFoUMwzRokw eISaf7/OgnKkUB3KwDlP0oaCK1e4ss6OD058sOKmpTKRQtKrn2oH7DM7DDzkElwN4Keq K0EqKG95jSCy6vhkx/wi38otP5g5rhW4fV8BxwEU/mcUjyiP/sIxw6X6z4sUCkybrl0g 6jhg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1741650833; x=1742255633; 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=++7pLyQ7UqPjDZ/zpi0EqmxvFy2RKpveJLK15H2O0Mw=; b=adxYRANRguvGzsMNJ0PUBDAq4GmZNiqiQD17/yrjnRonnSZI7nYoN1Z61c4QAehoQo VdggumbfPCmgIoWu8Xzg5ra2XFJyR5m1p/unO2TxZIx/mdCwo7ki+csYOoJhwxlaQrRT hFcSG1oCzbZPtdU7qVfAqQTHNCF34CNR3RT7coIgBCTNz7kFMglycBPvMFH74XEJ/Pva SH/8RZFixM7HtiT722mQ27iaI2PaYP5V+3N/Mst9TNJK4EZrFpxYYsMVCH9hwKeAorhu QeQdqfdNdjJAfXZDh88uLBSkqWL/3zyo0AjnaRKQ8Gf4GyX05Zg5U+jSjEU9ea4qH7fT yERg== X-Forwarded-Encrypted: i=1; AJvYcCWUPSwaFtGagy2fUbc7zVmoRLyoLkhwvinHGypXQNhNVJRe15Z23FZQKrnJaoe5WCyGay+jtRiRhOpnNm5x@lists.postgresql.org X-Gm-Message-State: AOJu0YzcSobdNY5mrdo+ZviWE3AgLN6rk32c3K+2yfidwlZCFM2dAoyS WmQsWioxXonE8ZgZsGUmKzZb3EKAR/D/KTY86fsQnnfOImfUvv3flbJ5B/W93g== X-Gm-Gg: ASbGnctFt+GBGKvHuVfE4cLAdm9WtsQuEoOUSGV1+8eP9aHBDhaiVMGKzRLC0WBEj6f Ez+p98AVNyU+krYyJdH7dzNtnFx4sAukhi4QBovseHm/JOyHd+aXioNPogcqqsDJqXaDVsedXMV xJN46hW7MvtSr/j7Kv0w2WvCl34+PcF96/HCTJI0+xt/uqXFzCpeKiS+kYlLfGKpKk4i1RNzl8Q p6vSkXSN1eryLz/31Jwl1gwDWvHUrgIdBVoR3PjrMmIE2vkTFaWTs6vlb8od+udzVMzh71hr0zJ g3Xc0/skuZauasV+23/Nb2wwTPaylIYFmm5jqGL+4DWwhS8HW79XjgThdvyFr13pdgD0bZTd696 DwHnC1AFnWx/9/w== X-Google-Smtp-Source: AGHT+IGajtr4mdEMrMMfFUernQURNxkoIKTfxQAp/hPGGmr21fdM0W89lJHRqF7IMAutD4km3fbuMA== X-Received: by 2002:a17:903:1790:b0:224:2a6d:55ae with SMTP id d9443c01a7336-2242a6d585emr241433085ad.48.1741650832747; Mon, 10 Mar 2025 16:53:52 -0700 (PDT) Received: from ?IPv6:2601:642:4c01:1a64:dac5:456e:6eb1:7084? ([2601:642:4c01:1a64:dac5:456e:6eb1:7084]) by smtp.gmail.com with ESMTPSA id d9443c01a7336-22410a908f9sm84733145ad.166.2025.03.10.16.53.51 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 10 Mar 2025 16:53:52 -0700 (PDT) Message-ID: <9a9090634e24b19ae1eff8a275f2db84f261c58f.camel@j-davis.com> Subject: Re: Statistics Import and Export: difference in statistics dumped From: Jeff Davis To: Tom Lane Cc: Ashutosh Bapat , Corey Huinker , Andres Freund , Michael Paquier , Nathan Bossart , Bruce Momjian , Matthias van de Meent , Magnus Hagander , Stephen Frost , Peter Smith , PostgreSQL Hackers , Alvaro Herrera , jian he Date: Mon, 10 Mar 2025 16:53:50 -0700 In-Reply-To: <1322262.1741643606@sss.pgh.pa.us> References: <97b451228227c555be1a4f79c4a62ddec9a74f06.camel@j-davis.com> <1457469.1740419458@sss.pgh.pa.us> <8d13e4296408c53a93390525d0bcb906cbd13df4.camel@j-davis.com> <768b2a237e892bf1334bdcbb066cdc1bd1368cb2.camel@j-davis.com> <5053263e41692dc2358a642403e9aa6fcda53578.camel@j-davis.com> <1116282.1741374848@sss.pgh.pa.us> <1322262.1741643606@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 Mon, 2025-03-10 at 17:53 -0400, Tom Lane wrote: > I wrote: > > I think what is happening is that the patch shut off CREATE > > INDEX's update of not only the table's stats but also the > > index's stats.=C2=A0 This seems unhelpful: the index's empty > > stats can never be what's wanted. >=20 > I looked at this more closely and realized that it's a simple matter > of having made the tests in the wrong order.=C2=A0 The whole stanza > should only apply when dealing with the table, not the index. >=20 > I verified that this change fixes the cross-version-upgrade > failure in local testing, and pushed it. Ah, thank you. Regards, Jeff Davis