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 <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1vW1uE-00B4xp-24
	for pgsql-hackers@arkaria.postgresql.org;
	Thu, 18 Dec 2025 00:30:11 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.96)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1vW1uD-00HDyr-1B
	for pgsql-hackers@arkaria.postgresql.org;
	Thu, 18 Dec 2025 00:30:10 +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 <andres@anarazel.de>)
	id 1vW1uD-00HDyi-0D
	for pgsql-hackers@lists.postgresql.org;
	Thu, 18 Dec 2025 00:30:09 +0000
Received: from fhigh-b3-smtp.messagingengine.com ([202.12.124.154])
	by magus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.96)
	(envelope-from <andres@anarazel.de>)
	id 1vW1uB-001Juy-0j
	for pgsql-hackers@lists.postgresql.org;
	Thu, 18 Dec 2025 00:30:09 +0000
Received: from phl-compute-02.internal (phl-compute-02.internal [10.202.2.42])
	by mailfhigh.stl.internal (Postfix) with ESMTP id 42BA07A01E5;
	Wed, 17 Dec 2025 19:30:06 -0500 (EST)
Received: from phl-frontend-04 ([10.202.2.163])
  by phl-compute-02.internal (MEProxy); Wed, 17 Dec 2025 19:30:06 -0500
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=anarazel.de; h=
	cc:cc:content-type:content-type:date:date:from:from:in-reply-to
	:in-reply-to:message-id:mime-version:references:reply-to:subject
	:subject:to:to; s=fm1; t=1766017806; x=1766104206; bh=4qUrWnyZK/
	gLhbFzifsk1q9jrGMd+PvAwHGVNi0AmiM=; b=aeRK2pHbLDhjcLoESZHYZMCl1v
	vpPs9YwP2hEAKSPanxIC9fAj1/R6wRSvM4ZlWYPNGtQTatVtxz0heTZ5LcX9IsGc
	vifDGPxcg2wdZi064s8DR+s7DVnkk+fACFkGpC4BKIhr6P/BMZ/2JkbyNBD7TToR
	zBc/jMbC8uSRlC36E5TWl/kiECkZ5j3JrqGL8xZaskrrYChl1vYrEglBX5LxEDou
	pH6CrvgnLZSM8Ea8nSeq5oGRHBLouUIoI5UzP+RgpHWS7zgFbNSuUYlmxlXLOJyw
	S/k3To2nPuY5y06yim7huE82rkUVQUbR5m/HCD0ZXHAlGzf2R1xV57tVhyrg==
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=
	messagingengine.com; h=cc:cc:content-type:content-type:date:date
	:feedback-id:feedback-id:from:from:in-reply-to:in-reply-to
	:message-id:mime-version:references:reply-to:subject:subject:to
	:to:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm1; t=
	1766017806; x=1766104206; bh=4qUrWnyZK/gLhbFzifsk1q9jrGMd+PvAwHG
	VNi0AmiM=; b=Vm7L/16QqYMqKFIwKnZptwTZhhpRPpRbqfHYdcPRacqsz0QRBU5
	aATKjqhiIZ5fPpzvR3G1nhsjRWToD3oJ9dCts1UGkus0YTw/l8PcjdshvGjta2Tx
	Uc3ptkRClp2vogEVAOONQgdx843eGfJqN1abT5nDAxr3rEc9WkECtlvhjr8pxbhn
	Bm/h1YWHkz13yt21qhdZjh3xSsJpkCqDHJGveb7HMTNIu3hh2KOSZWPTDQt8PTNn
	dr+94q2Sh2ip16SDAi2W6ulumsC9mvEOkV5qUXn3mZcpnhRXBKiXVrL+rL0t7YTL
	1fCy/aeXrk4HhfWZyKoaZKggGNqThLyTP0g==
X-ME-Sender: <xms:DUtDaZzE15KgVNKvlVh6Iv7FvPUTwyYlFfCCPgerkzN6-VJx3pViiQ>
    <xme:DUtDafR95sAlBuhNTVsTEH4R2D7SAuMCLWMlGSwWZoCG8k4NQnguHEdVrbQYeMoNN
    Ai_W9EO165fjtDvVKiekfedlmXW_h96U6xs45xn4R-BBsWT0bo0rQ>
X-ME-Received: 
 <xmr:DUtDaQ_PhSAoocCqlrAoYyqlzK5Oaac7E-lDE38U4j6g5qM8bePRCNBI49OjcDdyjVPO_g>
X-ME-Proxy-Cause: 
 gggruggvucftvghtrhhoucdtuddrgeefgedrtddtgdeggedttdcutefuodetggdotefrod
    ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpuffrtefokffrpgfnqfghnecuuegr
    ihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenucfjug
    hrpeffhffvvefukfhfgggtuggjsehttdfstddttddvnecuhfhrohhmpeetnhgurhgvshcu
    hfhrvghunhguuceorghnughrvghssegrnhgrrhgriigvlhdruggvqeenucggtffrrghtth
    gvrhhnpeetvdevvdetleeuleejlefhlefgvdffgefhleejlefgtdduvedvkeevgeeggfei
    ieenucffohhmrghinheptghirhhruhhsqdgtihdrtghomhenucevlhhushhtvghrufhiii
    gvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpegrnhgurhgvshesrghnrghrrgiivghl
    rdguvgdpnhgspghrtghpthhtohepvddpmhhouggvpehsmhhtphhouhhtpdhrtghpthhtoh
    epshhhihhnhigruddurdhkrghtohesghhmrghilhdrtghomhdprhgtphhtthhopehpghhs
    qhhlqdhhrggtkhgvrhhssehlihhsthhsrdhpohhsthhgrhgvshhqlhdrohhrgh
X-ME-Proxy: <xmx:DUtDaWrsrhxp7XWMBkmFDvqQJX_A3MqIwSTqGPPp9_tw-7dqX4H1lQ>
    <xmx:DUtDadliYCbX4tj3heHx_tCA4RUdYul0ek7Epe_tTi-6RuSO8B2Pqg>
    <xmx:DUtDadL3fNuSK7L8u5uW439034cLERJemPVvCb4sExs2-wohBEbr-g>
    <xmx:DUtDaSzjCCi2DYtwuaFONhX7ISaF6HQaOE4MsW3qT8Q8fytLPdtqww>
    <xmx:DktDaZDJqd9TypsRe6LcTBJ-ccBeTjIrTeYQuXsS5IFQY2nIfZCg8Jym>
Feedback-ID: id4a34324:Fastmail
Received: by mail.messagingengine.com (Postfix) with ESMTPA; Wed,
 17 Dec 2025 19:30:05 -0500 (EST)
Date: Wed, 17 Dec 2025 19:30:04 -0500
From: Andres Freund <andres@anarazel.de>
To: Shinya Kato <shinya11.kato@gmail.com>
Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Subject: Re: Report oldest xmin source when autovacuum cannot remove tuples
Message-ID: <3tgjs3plxazwnkr2shmmjlzsw6supdlrhzc7rrm2hhwz5hu24h@h4fiegd32jcv>
References: 
 <CAOzEurSgy-gDtwFmEbj5+R9PL0_G3qYB6nnzJtNStyuf87VSVg@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: 
 <CAOzEurSgy-gDtwFmEbj5+R9PL0_G3qYB6nnzJtNStyuf87VSVg@mail.gmail.com>
List-Id: <pgsql-hackers.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-hackers@lists.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-hackers>
Archived-At: 
 <https://www.postgresql.org/message-id/3tgjs3plxazwnkr2shmmjlzsw6supdlrhzc7rrm2hhwz5hu24h%40h4fiegd32jcv>
Precedence: bulk

Hi,

On 2025-10-31 15:31:40 +0900, Shinya Kato wrote:
> The patch is attached. What do you think?

The added tests never seem to pass in CI:
https://cirrus-ci.com/github/postgresql-cfbot/postgresql/cf%2F6188

Greetings,

Andres Freund