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

From Sami Imseih
Subject Re: Introduce some randomness to autovacuum
Date
Msg-id CAA5RZ0uTQGabav4vSTcrOTO-X9bX1A8E=xaqq1CEupcjxzN2Hg@mail.gmail.com
Whole thread Raw
In response to Re: Introduce some randomness to autovacuum  (Nathan Bossart <nathandbossart@gmail.com>)
List pgsql-hackers
> - Spinning. Running repeatedly on the same table but not accomplishing
> anything useful.

> But more importantly, IMHO it masks the problems instead of
> solving them more directly, and it could mask future problems, too

To add more to Nathan's comment about masking future problems,
this will not solve the "spinning" problem because if the most common
reason for this is a long-running transaction, etc., all your tables will
eventually end up with wasted vacuum cycles because the xmin
horizon is not advancing.

--
Sami Imseih



pgsql-hackers by date:

Previous
From: vignesh C
Date:
Subject: Re: Add an option to skip loading missing publication to avoid logical replication failure
Next
From: Greg Sabino Mullane
Date:
Subject: Re: Introduce some randomness to autovacuum