Re: another autovacuum scheduling thread

Robert Treat <rob@xzilla.net>

From: Robert Treat <rob@xzilla.net>

To: Nathan Bossart <nathandbossart@gmail.com>

Cc: David Rowley <dgrowleyml@gmail.com>, Sami Imseih <samimseih@gmail.com>, Robert Haas <robertmhaas@gmail.com>, Jeremy Schneider <schneider@ardentperf.com>, pgsql-hackers@postgresql.org

Date: 2025-11-11T19:50:55Z

Lists: pgsql-hackers

On Tue, Nov 11, 2025 at 2:49 PM Nathan Bossart <nathandbossart@gmail.com> wrote:
> On Tue, Nov 11, 2025 at 02:43:19PM -0500, Robert Treat wrote:
> > FWIW, when I have built these types of systems in the past, and when I
> > wanted an aggressive recheck-type mechanism, the most common methods
> > involved tying it to autovacuum_max_workers.
>
> Would you mind elaborating on this point?  Do you mean that you'd rebuild
> the list every a_m_w tables, or something else?
>

Yes.


Robert Treat
https://xzilla.net