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 1xH7qj-00000002psw-02g9 for pgsql-bugs@arkaria.postgresql.org; Wed, 14 Oct 2026 22:53:29 +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 1xH7qh-00000005l5M-49jX for pgsql-bugs@arkaria.postgresql.org; Wed, 14 Oct 2026 22:53:27 +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 1xH7qh-00000005l5E-2peV for pgsql-bugs@lists.postgresql.org; Wed, 14 Oct 2026 22:53:27 +0000 Received: from mail-dy1-x132f.google.com ([2607:f8b0:4864:20::132f]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1xH7qf-000000028x1-1Xbs for pgsql-bugs@lists.postgresql.org; Wed, 14 Oct 2026 22:53:27 +0000 Received: by mail-dy1-x132f.google.com with SMTP id 5a478bee46e88-35ca5244753so279009eec.2 for ; Wed, 14 Oct 2026 15:53:24 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1792018402; x=1792623202; 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=+MXIIs7U2oZZRyAbmmRWkfPmKONbvRI6ODbNuRsciws=; b=FDOIaqCTTOnz8Gh0St7pn9zsSTliSyZv+pGuvqA3/fxaMSr4skel1pLaAY10VLwOYu Airty+RLZPwy0QFl6oBkdoZGp5SrYXYbo9YVo6sqXKUREE60AiM1/qbWJo6OjeZnGeBN B8fTKXKcJmEMPtvnP61Z2EPtAQnZtvw2RXiNToid9rdYJRNKf8tsh+gCpZuFW8bOcRG7 65VNxlzmaClzWpe7JBj/KoQ3vdXYaiGCfBEBGsLQ9qlfk8PoAUaZaOs3Bn9+WgRwzDwB UGSqEDov+4Far+SUIuBy7YC0GjnpVXYFIEgM2cy0nwllsiLzDxNl1KqY8Gq8CeG0j6In Lyiw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20260707; t=1792018402; x=1792623202; 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=+MXIIs7U2oZZRyAbmmRWkfPmKONbvRI6ODbNuRsciws=; b=0d2vVz0xdg5wjOYNW4uFANYoUgGxBNso2I+pNdJovwzDRHKfirY1hBCQbbHoqQtZKy LtaoRPxmQtdpHCNPOaUq1IFBUax1EyrDUC/bnNT9XFSMCJTddXqnabAiK1TtQ//JOBTX B9PCvjduN4SljHRzASwVUYxitTK/HOOkMUBWWztnBgRgNxb1UJsHkb8lqcYLZgTE75Jv xtuWEUV2GM2rVD3ITwtWTJUL7CDuRnepW+nuqSdOPkKF03ImYGPjtou/kL+8TyvE+RRA PFVR8fWgwkCdmRgScbf25LhYubCu7J1XGjZ94WxZkT/3i/ANo11itnMzHgeazRzc39Xn LTGw== X-Gm-Message-State: AFq9FYKi3snyZkC1bRhllW/XlmBoKGzrGaXSe7mrTNxNddmurnWIxLjf k/xDe5UT6sQV4JsVMSuL3iixv2UA1QgAIS8hmttGlvtO6G7wmYMoR7rBBmizT4EK X-Gm-Gg: AYBFou2QduO09CaEMRO+GInkwlbmb0So9HpltCYJK8a44UBTvJK8Wi8kXOOtfB85zr8 R4whAgAj9/+EtBqeP6vxfFwiHxE9NcN/63u5Ru8Ozz80tSKFkniutck4tDWVvloT0575AGdg7yP 87whHYbz62HQZQp6Ogr7Z8aT727G76NO4rqrzciv3PbRw8W1QYxAiyu3L2nVZC5ZLvQfm/CwTlG wnD/nuSXfvCLdL5Bw+qrp6iwzel4UG9RG62hzUhHnwMGxj/+BVvnj2+ThW7cFHhhzhDEIW3IM6g 5HA6IkwlMEIY+NgYK2MWlgoIj20LYRcpCWxl5pQdfgKELNqjG82944Y6B/niJQsHSqmIwgabRSO 9CG5HWfgM8NUZpVH1iwWEaitLfZXIInd3IHf7XMRjJHbTwm5m+4YKQjkZnEM/+PWu58f02u+bvo lxzOOPmtm98rMf2nvUubzsmbTC+r5YVSqKz6qkyhtIVmwSVl6NVICj0Cf/rjJ4dm4prINFEaBW+ 0hoM1JVicADEZSL4hIa0DitPMtREnlaYqwqLtdGSbBDl3JlMN5IN/JS8pD+hQMToLIehqr2Vb5L V2EHzQLjb7ojD6DU0LkEeX4jEQ== X-Received: by 2002:a05:7300:f3c8:b0:351:7883:bf47 with SMTP id 5a478bee46e88-3537dc8e9c0mr36558216eec.0.1792018401589; Wed, 14 Oct 2026 15:53:21 -0700 (PDT) Received: from 192.168.1.109 ([2803:3c90:cee:ea00:5c3c:7e70:29e3:7a55]) by smtp.gmail.com with ESMTPSA id 5a478bee46e88-358ee8a3387sm47081585eec.15.2026.10.14.15.53.20 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 14 Oct 2026 15:53:21 -0700 (PDT) From: Manu To: pgsql-bugs@lists.postgresql.org Cc: Sebastian Webber , Staroverov Ilja Subject: Re: VACUUM/ANALYZE double-count the backend's own pending table stats Date: Wed, 14 Oct 2026 19:53:18 -0300 Message-ID: <179201839892.428296.16825605295501302418@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 Sebastian, > if a flush slips in between statements on a slow animal, it also > passes without the fix, so it may not catch a regression there. Good point. Pinning the flush in the test so it cannot pass without the fix is easy to add; I will leave that for Ilya's v2 unless he would rather I post it. Thanks also for the independent confirmation and the autovacuum numbers, and for digging up 81e82a2bd48 as a precedent. That settles the "just an approximation" question. Regards, Manu