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 1tle8E-000qCA-N5 for pgsql-hackers@arkaria.postgresql.org; Sat, 22 Feb 2025 01:16: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 1tle8D-002JdM-RL for pgsql-hackers@arkaria.postgresql.org; Sat, 22 Feb 2025 01:16:37 +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 1tle8D-002JdE-HP for pgsql-hackers@lists.postgresql.org; Sat, 22 Feb 2025 01:16:37 +0000 Received: from mail-ej1-x62c.google.com ([2a00:1450:4864:20::62c]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tle88-00049a-1x for pgsql-hackers@lists.postgresql.org; Sat, 22 Feb 2025 01:16:37 +0000 Received: by mail-ej1-x62c.google.com with SMTP id a640c23a62f3a-abb7a6ee2deso415904866b.0 for ; Fri, 21 Feb 2025 17:16:32 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1740186992; x=1740791792; darn=lists.postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=tWOmpfIxoeCINrgtC6H3CrsDqibcn7GPIHvuNh5PfFA=; b=VUPNtlx6u+M0HET1RYYgA/blGkVf/Lt9EeCL3Fol7GTzWF7Ju9Om2aT91p3rE3WOPw 22YojsCY6r/BBOQMk/qrzZTOEXfOH7LGOu/bH38VNfhtiA3xhUNENLsTx46PpRK32s9s B0XUnIOKgGCy7snfH12pSen0wtIUZUAM0zJ/xYgbqoUJ00z8C1952IOONifWdmM0bk8k 5Ziy8hAb3A9bx5i7dNOTt8lQjlyaE3NufcuWBx69Y3PU2JG2L5p9NSGeoFknOItJVsaz /92CncXGIIh/22gtZN3Y6XEI9LSuToVJrmAFhmTITcBqRDgg8TyKJiJcamz7ZLb0WVYU JSDg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1740186992; x=1740791792; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=tWOmpfIxoeCINrgtC6H3CrsDqibcn7GPIHvuNh5PfFA=; b=NxNNonQcu2EqR+IDGsUjGP4hR9u+z8D0JGvOJo3OB0UTPXMkqlWy55N5dYP6cfOYIx EW3BuJDhoFZHORVhYRq1A5Hri4+Gf+beT+P1KBYM8s1hyxny5WDh+cxC15v+zQ+a98mf ZtYmkJhv6u0k8jg37tKqxCLAXnpEuTvJgakdILbBkMP9V7T1gzSxh4+WCLE7WQqsxrJp za6a7TGDn1+A6cziupeh8L9mH/CugL+0nhaZZGyfUpVr0uOxPrZzkofhAKpVUU88RDrS FthC8sE2BullFHnu6J12OmK/521Y6vjpIbeMQi6uCybKM92H0toMunJs5tmZbawWNxZ4 fNWw== X-Forwarded-Encrypted: i=1; AJvYcCXFWYXIFiKbwXJ+Zo8SOVPMcTn2z93+kn+csHdH5kTuQ703Db45en9iW2lo6c1gjuN8KD2cDmBFXMMlBCsh@lists.postgresql.org X-Gm-Message-State: AOJu0Yz45jMClhcg+6T0m7qfHRaJjPGHeSnVjlDf0HU7Zixv6ovOND3F teX0dTZy0YzCnwjE386hdkzs8f1qp+t7L0CGVIuN+Et1kg1qonp2wCLvpc/Th80GgTWTJPsyQ+0 xE8jlZ1Hc1HudgzS/6yPz4DYU/4bqwQ== X-Gm-Gg: ASbGnctMYwPe79PYtE9y9xGME5KPbZ1VF7uswQBF4jrpAliWikXkadEfN/cFZV+Qnvi Z6Hwz05sitvMp4q4yS1jwY1fxglGSUDt7uRvsJvwPaq4wRa9PErv624l9tGgkVKP54WPSSjKlpF xDkJO3vGo= X-Google-Smtp-Source: AGHT+IE59b986/t4xqT27amLd+enCZpILOW9uNGj60ATqOq5Yg9Q+D2xZ73BY8Ak/OHqJoNizOiYROGKCbEOLX1XvM4= X-Received: by 2002:a17:907:9722:b0:aab:daf9:972 with SMTP id a640c23a62f3a-abc09ac1bd0mr468351866b.28.1740186991606; Fri, 21 Feb 2025 17:16:31 -0800 (PST) MIME-Version: 1.0 References: <70bc1af0-6910-4f71-84ba-fa02095fe9ba@tantorlabs.com> <3212947.1739306803@sss.pgh.pa.us> <3365160.1739385615@sss.pgh.pa.us> <0e4c813a-18eb-41e2-8edb-89b78d43c82d@gmail.com> <01ec86c1-e04b-4cbe-b641-22cae8b87604@tantorlabs.com> <73e2440e-7d8b-4860-974d-931a93326d95@gmail.com> <3737950.1740182671@sss.pgh.pa.us> In-Reply-To: <3737950.1740182671@sss.pgh.pa.us> From: Robert Haas Date: Fri, 21 Feb 2025 20:16:20 -0500 X-Gm-Features: AWEUYZmCx5UK4abo9MQmsr6oDEJ671XeYSW6d1rTBP2xQ4jjG0mqgIxyc_GJMKo Message-ID: Subject: Re: explain analyze rows=%.0f To: Tom Lane Cc: Ilia Evdokimov , Andrei Lepikhov , pgsql-hackers@lists.postgresql.org Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, Feb 21, 2025 at 7:04=E2=80=AFPM Tom Lane wrote: > Sounds plausible. I note that this run: > > https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=3Dskimmer&dt=3D20= 25-02-21%2023%3A00%3A10 > > got through a couple of iterations of the core tests before failing, > showing that it's not 100% reproducible even on the machines where > it's happening. Yeah, I pushed an attempt at a band-aid fix. Hopefully that will make it clear whether there are other problems and how bad they are. It looks like the XversionUpgrade tests are not this commit's fault. --=20 Robert Haas EDB: http://www.enterprisedb.com