Re: Testing autovacuum wraparound (including failsafe)

Поиск
Список
Период
Сортировка
От Peter Geoghegan
Тема Re: Testing autovacuum wraparound (including failsafe)
Дата
Msg-id CAH2-Wz=KDNbv-8ZhN4q1_8V70P8MqeJjfNHgh0GWgKEjf_f+4Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Testing autovacuum wraparound (including failsafe)  (Andres Freund <andres@anarazel.de>)
Ответы Re: Testing autovacuum wraparound (including failsafe)
Список pgsql-hackers
On Fri, Apr 23, 2021 at 7:53 PM Andres Freund <andres@anarazel.de> wrote:
> I mainly suggested it because to me the current seems hard to
> understand. I do think it'd be better to check more often. But checking
> depending on the amount of dead tuples at the right time doesn't strike
> me as a good idea - a lot of anti-wraparound vacuums will mainly be
> freezing tuples, rather than removing a lot of dead rows. Which makes it
> hard to understand when the failsafe kicks in.

I'm convinced -- decoupling the logic from the one-pass-not-two pass
case seems likely to be simpler and more useful. For both the one pass
and two pass/has indexes case.

-- 
Peter Geoghegan



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Amit Kapila
Дата:
Сообщение: Re: [bug?] Missed parallel safety checks, and wrong parallel safety
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: multi-install PostgresNode fails with older postgres versions