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.96) (envelope-from ) id 1w7EHz-0055ta-0Q for pgsql-hackers@arkaria.postgresql.org; Mon, 30 Mar 2026 15:12:27 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w7EHx-004FPx-1v for pgsql-hackers@arkaria.postgresql.org; Mon, 30 Mar 2026 15:12:26 +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.96) (envelope-from ) id 1w7EHx-004FPp-0C for pgsql-hackers@lists.postgresql.org; Mon, 30 Mar 2026 15:12:25 +0000 Received: from fout-b4-smtp.messagingengine.com ([202.12.124.147]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1w7EHu-000000020tS-1NMZ for pgsql-hackers@postgresql.org; Mon, 30 Mar 2026 15:12:25 +0000 Received: from phl-compute-03.internal (phl-compute-03.internal [10.202.2.43]) by mailfout.stl.internal (Postfix) with ESMTP id DB9F11D000F0; Mon, 30 Mar 2026 11:12:20 -0400 (EDT) Received: from phl-frontend-04 ([10.202.2.163]) by phl-compute-03.internal (MEProxy); Mon, 30 Mar 2026 11:12:20 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=kurilemu.de; h= cc:cc:content-transfer-encoding:content-type:content-type:date :date:from:from:in-reply-to:in-reply-to:message-id:mime-version :reply-to:subject:subject:to:to; s=fm3; t=1774883540; x= 1774969940; bh=auMxM+1xBv5QOKO/lwf6bBfN+BkGNJihhT7lq/aap/U=; b=t gSw+9PZheCXBUsLOn4CT27C+yPqyQR/D2u4U8FkA99LVrhIl0FJ2HMtu8c/Tz6M1 pATz2Fi/U66yD6dnOlVQ4z3NvepF+3FrU8A6vUPicqB5uKwmvdK0j117Po0Yc0HR 7t0MHvJuhMgvAKvWQhv6Wr9zosVUNIj9F5V98ymFHzMsmXYxBxbCkn7sYYZfe5VC 7t8qtybhz+z5qRaCdoRslZYDROuT8BSLLG/2bLNK2JqNsMmQwcPQq8DkqEDW9dEz qRw+VHABUlSCsTkzbXLXNydnOOqNqi7WJmBink0HfT/FffYbfNZsvIDScSHTIrJE jPGrUCE2L5iKqffm5gEZA== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:content-type:date:date:feedback-id:feedback-id :from:from:in-reply-to:in-reply-to:message-id:mime-version :reply-to:subject:subject:to:to:x-me-proxy:x-me-sender :x-me-sender:x-sasl-enc; s=fm1; t=1774883540; x=1774969940; bh=a uMxM+1xBv5QOKO/lwf6bBfN+BkGNJihhT7lq/aap/U=; b=pbO6MSBOpaE4DY/J5 clYVXsUGnwO3nIv2GnYG7Htni4/aMTz6Ji+AkaGllQwai4PI+P8g7ua/Lt17AZtc CS8j0lKXLSLJ6nqrb9Pxbv39A2a8ueoUvd3gSP7kET6oOD3rkyBFI45NBDi+2IJy ZenLXQi3UhIw51JFBBNDNw0WLwiOANMLwBuXuaLM31XDccE06ipxPlhGnq4mJtcf A/F5KVZMvlGXqFbgD64nLvSiHlBNfMljvdSnWj3clxCjz16a7dlAIUhaNAhUhlAf GVJDd+0F3IJGTN9oUK0f9Mv4d9rQoC+34/p1atFLavHsXH2YqT4NcdAOqj5Kl0X3 i+/qg== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefgedrtddtgdeffeelfeduucetufdoteggodetrf dotffvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfurfetoffkrfgpnffqhgenuceu rghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmnegouf hushhpvggtthffohhmrghinhculdegledmnecujfgurhepfffhvfevuffkgggtugfgjges thekredttddtjeenucfhrhhomheplmhlvhgrrhhoucfjvghrrhgvrhgruceorghlvhhhvg hrrhgvsehkuhhrihhlvghmuhdruggvqeenucggtffrrghtthgvrhhnpeduheejhfeugfet geduleejieejuddvffffueejueduteefheeiheetffeijedtgfenucffohhmrghinhepvg hnthgvrhhprhhishgvuggsrdgtohhmpdhgohhoghhlvgdrtghomhenucevlhhushhtvghr ufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpegrlhhvhhgvrhhrvgeskhhurh hilhgvmhhurdguvgdpnhgspghrtghpthhtohepvddpmhhouggvpehsmhhtphhouhhtpdhr tghpthhtohepshgrmhhimhhsvghihhesghhmrghilhdrtghomhdprhgtphhtthhopehpgh hsqhhlqdhhrggtkhgvrhhssehpohhsthhgrhgvshhqlhdrohhrgh X-ME-Proxy: Feedback-ID: ie3de48e3:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Mon, 30 Mar 2026 11:12:20 -0400 (EDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=kurilemu.de; s=schmee; t=1774883537; bh=IgZDIUGIgkrm9BQ33g3GTFuk1N+1NiOy+GxvA3vmfzY=; h=Date:From:To:Cc:Subject:In-Reply-To:From; b=k7X+KObpLRkKpIGFdhCp6CfZjsGyUCjnzFn22W044NSCRx9w1aDxy6q+4VZ/cOATF GyYQNGdhL1xT+ay6UHISonRoL4SHemO6lCtaIpZ/9xehJ8eIE/B8pBg9qV+Md4UP4k QnxncmmYc8Kz7vP7aAzjuw3ZLxNJVYLMqk+NVVCRNIkP8dr8kFTWOt76m1BScr5S2V af1dLEvQAy6j50QxqljlYHIQEyjqaNAj4zaJZ0R3AmMZQo7pdLAKxhw4LEuwHHw/0o zvbiHol8SWE1Wpju+gkbdF7MZk8loVmwKsenQXppnom9HEK8AY5KjZJW2S8hPxGsRZ O2OPJpfP0GYOg== Received: by schmee.kurilemu.internal (Postfix, from userid 1000) id 53FFE7C; Mon, 30 Mar 2026 17:12:17 +0200 (CEST) Date: Mon, 30 Mar 2026 17:12:17 +0200 From: =?utf-8?Q?=C3=81lvaro?= Herrera To: Sami Imseih Cc: pgsql-hackers Subject: Re: Add pg_stat_autovacuum_priority Message-ID: <202603301508.up22nvhgnnoj@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 2026-Mar-27, Sami Imseih wrote: > 0002 introduces the view with documentation and testing in > vacuum.c (xid age and mxid age scores are not tested as > they require xid_wraparound to consume enough XIDs to > trigger a score, which will cost too much time for a > regression test). After this patch, there are three copies of the combined call to pgstat_fetch_stat_tabentry_ext() and relation_needs_vacanalyze(). Can we avoid that, ideally reducing to only one such? Or, at least, it looks like recheck_relation_needs_vacanalyze() may no longer need to exist at all. -- Álvaro Herrera PostgreSQL Developer — https://www.EnterpriseDB.com/ "Ed is the standard text editor." http://groups.google.com/group/alt.religion.emacs/msg/8d94ddab6a9b0ad3