Horton

Re: Introduce some randomness to autovacuum

Greg Sabino Mullane <htamfids@gmail.com>

View thread
From: Greg Sabino Mullane <htamfids@gmail.com>
To: Junwang Zhao <zhjwpku@gmail.com>
Cc: Nikita Malakhov <hukutoc@gmail.com>, wenhui qiu <qiuwenhuifx@gmail.com>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2025-04-30T17:06:35Z
Lists: pgsql-hackers 
On Wed, Apr 30, 2025 at 10:07 AM Junwang Zhao <zhjwpku@gmail.com> wrote:

> I ended up with adding a guc configuration that may support different
> vacuum
> strategies.


+1 to this: it's a good solution to a tricky problem. I would be a -1 if
this were not a GUC.

Yes, it is masking the problem, but maybe a better way to think about it is
that it is delaying the performance impact, allowing more time for a manual
intervention of the problematic table(s).

Cheers,
Greg

--
Crunchy Data - https://www.crunchydata.com
Enterprise Postgres Software Products & Tech Support