Date: Sat, 30 May 2026 02:31:27 +0000
To: Laurenz Albe <laurenz.albe@cybertec.at>
From: Scott Ray <scott@scottray.io>
Cc: Shinya Kato <shinya11.kato@gmail.com>, Japin Li <japinli@hotmail.com>,
 wenhui qiu <qiuwenhuifx@gmail.com>, Sami Imseih <samimseih@gmail.com>,
 PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Subject: Re: Report oldest xmin source when autovacuum cannot remove tuples
Message-ID: 
 <3bnBUxwx2npXqvHL0trI11LOOvzQ7LI0GzWqbaj5SJnk7DTb1uzStGveKwj0JJmBW4ebzGIF3az7of4I4rQeaO_PRqDnnClCduPyjM6gPgM=@scottray.io>
In-Reply-To: <6634e1b0b5b74e5c2e3b06201120a81e11d82a55.camel@cybertec.at>
References: 
 <CAOzEurSgy-gDtwFmEbj5+R9PL0_G3qYB6nnzJtNStyuf87VSVg@mail.gmail.com>
 <CAOzEurTNVkvvscKeEOy0WwfzyqO+J_MyXwkjRteJ_zyydteKCQ@mail.gmail.com>
 <CAGjGUAK6j4K3OMocdtPZRwTyF_U7Y47-bzxUDu4ZeUdg35Vtnw@mail.gmail.com>
 <SY7PR01MB109210F944A86A8771BC5EE2AB640A@SY7PR01MB10921.ausprd01.prod.outlook.com>
 <CAOzEurSa37w_wgP7SeVicsoo5ERXc4V7XQH2xee5YM-W9uRRBA@mail.gmail.com>
 <SY7PR01MB10921CD524617DCF4FE8E2565B60C2@SY7PR01MB10921.ausprd01.prod.outlook.com>
 <CAOzEurS5s9cbXP7XT0EHe9KynLqsjJt56mqL+ZAPKD0jvrYPBw@mail.gmail.com>
 <CAOzEurRAiBfN-f5juywYzjS+5rWXTSSr3jaVaCJ39TJnwvUimQ@mail.gmail.com>
 <6634e1b0b5b74e5c2e3b06201120a81e11d82a55.camel@cybertec.at>
Feedback-ID: 189710061:user:proton
MIME-Version: 1.0
Content-Type: multipart/signed; protocol="application/pgp-signature";
 micalg=pgp-sha512;
 boundary="------881d80f5a84d6a32c42ef23e24a0bb93884d71573ee7a65b8130f2907d46b036";
 charset=utf-8
Archived-At: 
 <https://www.postgresql.org/message-id/3bnBUxwx2npXqvHL0trI11LOOvzQ7LI0GzWqbaj5SJnk7DTb1uzStGveKwj0JJmBW4ebzGIF3az7of4I4rQeaO_PRqDnnClCduPyjM6gPgM%3D%40scottray.io>
Precedence: bulk

This is an OpenPGP/MIME signed message (RFC 4880 and 3156)
--------881d80f5a84d6a32c42ef23e24a0bb93884d71573ee7a65b8130f2907d46b036
Content-Type: multipart/mixed;boundary=---------------------adf61d28d726b7b08dbf3aef0d07bf1c

-----------------------adf61d28d726b7b08dbf3aef0d07bf1c
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;charset=utf-8

> I guess the overhead of one more scan of the process array for every aut=
ovacuum
> run if "log_autovacuum_min_duration" is non-zero (which is the default)
> is acceptable.


Could vacuum compute the blocker during ComputeXidHorizons and consume it =
at log time?
Avoids the extra scan, and binds the blocker to the horizon vacuum used fo=
r pruning.

Scott Ray
-----------------------adf61d28d726b7b08dbf3aef0d07bf1c--

--------881d80f5a84d6a32c42ef23e24a0bb93884d71573ee7a65b8130f2907d46b036
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: ProtonMail

wrsEARYKAG0FgmoaS/EJENJWjBT/u5s7RRQAAAAAABwAIHNhbHRAbm90YXRp
b25zLm9wZW5wZ3Bqcy5vcmfKZul4YWuGSjLZpIC8FmHRX95cxma+2G4Z9Mg+
eSCr+RYhBHp15mAbLriqt8a+vNJWjBT/u5s7AABo+AD+NY28s26eIgl2sEDo
B1oVbIaDcQuTI+f6tSNbVTAxoFEBAN81byKc574jcu70+Oa2R7UfDfNvGJYP
qHYEhOsq4ggG
=y/2/
-----END PGP SIGNATURE-----


--------881d80f5a84d6a32c42ef23e24a0bb93884d71573ee7a65b8130f2907d46b036--