Re: another autovacuum scheduling thread - Mailing list pgsql-hackers

From Sami Imseih
Subject Re: another autovacuum scheduling thread
Date
Msg-id CAA5RZ0v3uCOV16c=q2dRR+xdZDzC=wveGuVqiZZm0Taq7=q+pg@mail.gmail.com
Whole thread Raw
In response to Re: another autovacuum scheduling thread  (Sami Imseih <samimseih@gmail.com>)
List pgsql-hackers
> Not saying that the current approach, which is as you mention is
> random, is any better, however this approach will likely increase
> the behavior of large tables saturating workers.

Maybe it will be good to allocate some workers to the oldest tables
and workers based on some random list? This could balance things
out between the oldest (large) tables and everything else to avoid
this problem.

--
Sami Imseih
Amazon Web Services (AWS)



pgsql-hackers by date:

Previous
From: Ants Aasma
Date:
Subject: Re: sync_standbys_defined and pg_stat_replication
Next
From: Andres Freund
Date:
Subject: Re: Should we update the random_page_cost default value?