Horton

Re: Report oldest xmin source when autovacuum cannot remove tuples

Laurenz Albe <laurenz.albe@cybertec.at>

View thread
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Shinya Kato <shinya11.kato@gmail.com>, Japin Li <japinli@hotmail.com>
Cc: wenhui qiu <qiuwenhuifx@gmail.com>, Sami Imseih <samimseih@gmail.com>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2026-05-23T13:35:37Z
Lists: pgsql-hackers 
On Sat, 2026-05-23 at 15:00 +0900, Shinya Kato wrote:
> Oops, I made a slight mistake. Fixed.

I think that is a great feature that will improve users' lives!

The patch looks fine to me too.
I guess the overhead of one more scan of the process array for every autovacuum
run if "log_autovacuum_min_duration" is non-zero (which is the default)
is acceptable.

Yours,
Laurenz Albe