Re: Introduce some randomness to autovacuum

Поиск
Список
Период
Сортировка
От Sami Imseih
Тема Re: Introduce some randomness to autovacuum
Дата
Msg-id CAA5RZ0uTQGabav4vSTcrOTO-X9bX1A8E=xaqq1CEupcjxzN2Hg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Introduce some randomness to autovacuum  (Nathan Bossart <nathandbossart@gmail.com>)
Список 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 по дате отправления: