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 1vBb61-0018Ze-Oy for pgsql-hackers@arkaria.postgresql.org; Wed, 22 Oct 2025 15:49:53 +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 1vBb60-00HXyX-EJ for pgsql-hackers@arkaria.postgresql.org; Wed, 22 Oct 2025 15:49:51 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1vBb60-00HXyP-2q for pgsql-hackers@lists.postgresql.org; Wed, 22 Oct 2025 15:49:51 +0000 Received: from fhigh-a1-smtp.messagingengine.com ([103.168.172.152]) by makus.postgresql.org with smtp (Exim 4.96) (envelope-from ) id 1vBb5u-003BTR-1r for pgsql-hackers@postgresql.org; Wed, 22 Oct 2025 15:49:50 +0000 Received: from phl-compute-10.internal (phl-compute-10.internal [10.202.2.50]) by mailfhigh.phl.internal (Postfix) with ESMTP id E1BD814001E6; Wed, 22 Oct 2025 11:49:45 -0400 (EDT) Received: from phl-mailfrontend-01 ([10.202.2.162]) by phl-compute-10.internal (MEProxy); Wed, 22 Oct 2025 11:49:45 -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=fm1; t=1761148185; x= 1761234585; bh=n/FMSBPP2tcpz4yTsQHTpQgmdrITVx+vZ8USC+W/PjM=; b=G c+B6AmMFE0EPlTh0ep1iHbjhDA+S50h55p7WmY0hDewXiZ9FaZ8AVQbYNlGAJlhm hZevtJ6BAoEQ8jWBSLnw3UFc8TjzEV2/LbQNOCncgX6tJ/fP8wNo+w4XPuhpva3e ZzWCMk86nMBfJ/cLCF41DMOE9sOW5iyPOpGpZDPjZk/UWp9UfLeLT9CP6tT+Ymwp Rq6mlMRwLGdb3Efc8BxzQw/SD7WL7cmS/9wmWpFOMCAcUkSHDUKrCybHyS407e8U msab+loUAUUaVJ3RQyDYDn0mYmi/V7mixv8LhF05N1827SjXxIswQiUOCyXG3qZQ shSOSiA9gqC60CD4JNg5g== 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=fm2; t=1761148185; x=1761234585; bh=n /FMSBPP2tcpz4yTsQHTpQgmdrITVx+vZ8USC+W/PjM=; b=LKmHBemR8Ea7tl7kR RaCYzxPFnXeM/IPDvGLD86zPZdHtanMcOXxVZcghxVDOcdoZ2B8++V5SdLIHTytA 95C2NgMVDhTGJOjsLeKRL1pQm2TwesO/qiQBH0ZbaeXIfDNn9EmChxzalfMeB1OV qW/CMtJMXKwTh5CiatmuegU701VB/0N8KWCkvSGfB14W9Di/YP7Hdk39BdNzDVvF yWRPF60G6/EeOCRbZvOSWNyPebsKx2SUJyGVj/2m/t1xNsZYYmMx+7QMqatAsPTZ Od4lMk9n2Qvsi0RoWYwZoCcicfpTFwcdtrtF36uh9zGiVGQlNmKlDzPQQB9urQJm ctOaw== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeeffedrtdeggddugeefleekucetufdoteggodetrf dotffvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfurfetoffkrfgpnffqhgenuceu rghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmnecujf gurhepfffhvfevuffkgggtugfgjgesthekredttddtjeenucfhrhhomheplmhlvhgrrhho ucfjvghrrhgvrhgruceorghlvhhhvghrrhgvsehkuhhrihhlvghmuhdruggvqeenucggtf frrghtthgvrhhnpeetuedvheffkeevgfeuheevteevkefggedttdeufeeuheduuddthfef fffhjeefffenucffohhmrghinhepvghnthgvrhhprhhishgvuggsrdgtohhmnecuvehluh hsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomheprghlvhhhvghrrhgv sehkuhhrihhlvghmuhdruggvpdhnsggprhgtphhtthhopedutddpmhhouggvpehsmhhtph houhhtpdhrtghpthhtohepjhhovghlsegtohhmphhilhgvrhdrohhrghdprhgtphhtthho peefuggrnhhishhsihhmohesghhmrghilhdrtghomhdprhgtphhtthhopegrlhgvgigrnh gurhgrrdifrghnghdrohhsshesghhmrghilhdrtghomhdprhgtphhtthhopegrrhhsvghn ihihrdhmuhhkhhhinhdruggvvhesghhmrghilhdrtghomhdprhgtphhtthhopehmrghthh gvuhhsshhsihhlvheljeesghhmrghilhdrtghomhdprhgtphhtthhopehrihhshhhurdhp ohhsthhgrhgvshesghhmrghilhdrtghomhdprhgtphhtthhopehsrgifrggurgdrmhhshh hksehgmhgrihhlrdgtohhmpdhrtghpthhtohephidrshhokhholhhovhesphhoshhtghhr vghsphhrohdrrhhupdhrtghpthhtohepphhgshhqlhdqhhgrtghkvghrshesphhoshhtgh hrvghsqhhlrdhorhhg X-ME-Proxy: Feedback-ID: ie3de48e3:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Wed, 22 Oct 2025 11:49:44 -0400 (EDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=kurilemu.de; s=schmee; t=1761148183; bh=TjHyWfVuCTJcG/N4lfStoOUTUUrq9g2N6Ghqs9Cg3yQ=; h=Date:From:To:Cc:Subject:In-Reply-To:From; b=ZE1i6ab9PUsqu+2+BnCokGjiO5Dwjft2hI5R6BpFrOa1ykjtwGNx7XZsCvmNhLEN8 GvNIttCK7gMm51FRqPY0+zUl/E2zWs5Rs2FZEeNbF1wNjK2fgbliTXs+7WT6/mZ9wq YG3agnVRF6PvUgL14WJBU5nmMTh6ES8FUva6rOpOZat/NJjM+K+MwcYLW+XNIe4kC8 Y48JhgeElU9E7e5YfiPjyNyOz96vjHlVmQlI67slI3AhOyr0yu0t7JTBhnu3y0j7Ui tM+1JuoZFuoA/VoKcldxhHLxjraWQGmlymUxoqIHA7CxMemYnJ0/+LTmGgwZ5OjL7V QPJEOtfEQXlIA== Received: by schmee.kurilemu.internal (Postfix, from userid 1000) id 9E79C6A; Wed, 22 Oct 2025 17:49:43 +0200 (CEST) Date: Wed, 22 Oct 2025 18:49:43 +0300 From: =?utf-8?Q?=C3=81lvaro?= Herrera To: Matheus Alcantara Cc: Masahiko Sawada , Joel Jacobson , Arseniy Mukhin , Rishu Bagga , Yura Sokolov , Daniil Davydov <3danissimo@gmail.com>, Alexandra Wang , pgsql-hackers , Tom Lane Subject: Re: LISTEN/NOTIFY bug: VACUUM sets frozenxid past a xid in async queue Message-ID: <202510221548.tgggefdrlpo3@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 2025-Oct-22, Matheus Alcantara wrote: > I'm wondering if the 002_aborted_tx_notifies.pl is still needed with > this architecture being used. I think that it's not, but perhaps is a > good test to keep it? I'd rather have tests than not, but I'd think it needs to be behind PG_TEST_EXTRA because of things like +$node->safe_psql('postgres', 'select consume_xids(10000000);'); -- Álvaro Herrera PostgreSQL Developer — https://www.EnterpriseDB.com/ "Hay quien adquiere la mala costumbre de ser infeliz" (M. A. Evans)