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 1xHGH0-00000002uQy-2n0D for pgsql-bugs@arkaria.postgresql.org; Thu, 15 Oct 2026 07:53:10 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.98.2) (envelope-from ) id 1xHGGy-00000007XRo-1CW7 for pgsql-bugs@arkaria.postgresql.org; Thu, 15 Oct 2026 07:53:08 +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.98.2) (envelope-from ) id 1xHGGx-00000007XRe-4AIq for pgsql-bugs@lists.postgresql.org; Thu, 15 Oct 2026 07:53:08 +0000 Received: from mail-dy1-x1329.google.com ([2607:f8b0:4864:20::1329]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1xHGGv-00000002D4H-3SWS for pgsql-bugs@lists.postgresql.org; Thu, 15 Oct 2026 07:53:07 +0000 Received: by mail-dy1-x1329.google.com with SMTP id 5a478bee46e88-313bab9cfe7so603971eec.3 for ; Thu, 15 Oct 2026 00:53:05 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1792050783; x=1792655583; darn=lists.postgresql.org; h=mime-version:content-transfer-encoding:content-type:references :in-reply-to:message-id:date:subject:cc:to:from:from:to:cc:subject :date:message-id:reply-to:content-type; bh=Z2jQZME8zTdwmrA9/roebDN90J9iIAWi7uckvbiiWj8=; b=s+J91WIMJcNHcTWxut9GFlHlV7enFQ6iuTgR3CyiAa9gjuVTG6dhKgVQInwwhjglMb 01oF2QLTi2maDP4l2gYQTG4LrsmIFBBhn3ecgSJ762dw4F5MUp31NYT6WaU3kadhHpnA C0MdGaUNL3Xyw2gUzJ+5wqDsWRZm8WAseQWnFdcMymmHNm8CD6b9/OenxK6swk4onrBI 2akC8c2AVjuDsdi3tFrXh9e+jZQ4nCyRmdBzBW2NZhJ/huC/Q0QFihkTx+zRzE3c3mr4 d3u8P08cfxKaEI/F8ZpQcIRV+jllHTU51dnNkn0mKjSSw9t82IVW+PXXTYT4xNOKOMIQ FcNg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20260707; t=1792050783; x=1792655583; h=mime-version:content-transfer-encoding:content-type:references :in-reply-to:message-id:date:subject:cc:to:from:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to :content-type; bh=Z2jQZME8zTdwmrA9/roebDN90J9iIAWi7uckvbiiWj8=; b=ho7/lYUFCk3kpYH4jCTt1v22v4AjrQEWBHzS6J9Bve9WdUGQWRtCGeKe/yiMWFgRs/ t6WAqUYu6x15QoZFmZsCKCJptjhBC6xC+vFK2zwcsLhbxYnLdWhWvIcNUnhUsauzf5Tw f8At3EygryqVU+jM6GxM8fodWSpvP6c5kjXsj48+m1rtw44WG2KF1yRFlVz55IEox3Yn 2wqF+IEc9oQzU95s1xq85/4/r3NeqbNikJXGM5WjTIckXIpJQQ/5h1hH/ffGFPG4B8+7 M84K6wZW4JWNIV0xPhWj2VGb0OtPf1dtO3PgJnMk+fxdiwNXKVyOSuU16UXLph3BS2Zo oDIQ== X-Gm-Message-State: AFq9FYLUH215I0a94XW0zM07jXihagahYiCITZKQgbRSpCxK/JM4JDfZ hIC9PryWHuOTrQy1StS6i057pPNdkPx1iB+b4CVmKW1yaW7lsmrHtnJ3Gq3a7CscZi8= X-Gm-Gg: AYBFou0uoQUqEDGiiwIPtDEQ9tc3xQ9T/CThM/84f8MdhTnXt5IIwZXtQKAkqD4a0gP 39FRHB5aBWv2l7D9HuB5olqnYAwuyJ55fqQo06tFuLt89N75lmz/yRYVhrSBQRVmezADsk1cfED sPkzZD9y+I5XMspSoUvEP2JS8U0fN7Rf61Cg/mtTPO5Rhp3PDUoHrZfM4mbRXKJfOQkdsZl0T1R HEorxwmzZm9tmpOWZ5PgyrXzvzfgYF7tRey+xH/zJhERxndpa5HlIz5nZaXplcTSYfVb5wkH8tF 7vOuMax3N4QyIa6D5u3rYHAeUVzr9WVrYbwUSxHyVJvnMv/vpUuPlDn14wgGDrp+8F7KLyTqa9z 9ZXoijP+6uadXGd++WNKwofHzVOhA6/u2wyXUjRu/toqWjgWR9q3AtlsNCstTRvzJ0mSK8XckWN 3VMuM69KY6rHuMEpk0HWRruPqKxG/FkSWFPkLPf0hS4pDUvVSxv8QBVnKYvIJ7RIiloLDI7cKaP uNbgotPbdHojTIqWXb3FZozGDNlnwJOE/ZFeXKilWo5oEoATedpZZq1fkB6uvQbJ/pLjEiEF3Th wbfe3bcyo4AQ1JQg7SGXWCA= X-Received: by 2002:a05:7300:da12:b0:35d:4c5b:766c with SMTP id 5a478bee46e88-35d4c5b7a5cmr11262504eec.2.1792050782821; Thu, 15 Oct 2026 00:53:02 -0700 (PDT) Received: from 192.168.1.8 ([2803:3c90:cee:ea00:5c3c:7e70:29e3:7a55]) by smtp.gmail.com with ESMTPSA id 5a478bee46e88-35de709d928sm14446060eec.25.2026.10.15.00.53.01 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 15 Oct 2026 00:53:02 -0700 (PDT) From: Manu To: pgsql-bugs@lists.postgresql.org Cc: Staroverov Ilja , Sebastian Webber Subject: Re: VACUUM/ANALYZE double-count the backend's own pending table stats Date: Thu, 15 Oct 2026 04:52:59 -0300 Message-ID: <179205077939.3306206.6672924540459449128@gmail.com> In-Reply-To: References: Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi Ilya, Thanks for confirming the repros, and agreed on keeping the VACUUM case best-effort. > would you like to take them to a separate thread yourself? Yes, I'll take P1 and P2 to their own thread and post them with a fix; since they reach back to 14 that keeps this one small enough to back-patch. I'll CC you. Regards, Manu