Postgres Pro
Downloads
Home   >   mailing lists

Re: Introduce some randomness to autovacuum - Mailing list pgsql-hackers

From Nikita Malakhov
Subject Re: Introduce some randomness to autovacuum
Date
Msg-id CAN-LCVPrwcOAi8syb9C_mLk7uSxrAdK0_xb2XiMZCiKwX=C41g@mail.gmail.com
Whole thread Raw
In response to Re: Introduce some randomness to autovacuum  (wenhui qiu <qiuwenhuifx@gmail.com>)
Responses Re: Introduce some randomness to autovacuum
List pgsql-hackers
Tree view
Hi!

I agree it is a good idea to shift the table list. Although vacuuming larger tables first
is a questionable approach because smaller ones could wait a long time to be vacuumed.
It looks like the most obvious and simple way is that the first table to be vacuumed
should not be the first one from the previous iteration.

On Fri, Apr 25, 2025 at 6:04 PM wenhui qiu <qiuwenhuifx@gmail.com> wrote:
Hi，I like your idea，It would be even better if the weights could be taken according to the larger tables


--
Regards,
Nikita Malakhov
Postgres Professional
The Russian Postgres Company

pgsql-hackers by date:

Previous
From: Nikhil Kumar Veldanda
Date:
Subject: Re: ZStandard (with dictionaries) compression support for TOAST compression
Next
From: Fujii Masao
Date:
Subject: Questions about logicalrep_worker_launch()