Re: Fwd: PG12 autovac issues

Поиск
Список
Период
Сортировка
От Michael Lewis
Тема Re: Fwd: PG12 autovac issues
Дата
Msg-id CAHOFxGoDBxRfjm04K+qNH4sifrTaBM=_xQY8jA7AJjUgsvCurw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Fwd: PG12 autovac issues  (Adrian Klaver <adrian.klaver@aklaver.com>)
Ответы Re: Fwd: PG12 autovac issues
Список pgsql-general
Do you have default fillfactor set on this table? If not, I would wonder if reducing it to 50% or even 20% would allow many more HOT updates that would reduce bloat.

Also, is there any period of lower activity on your system that you could schedule a vacuum freeze for daily or weekly? I believe having frozen pages would also mean all the autovacuums would be able to skip more pages and therefore be faster.

>> autovacuum_vacuum_cost_delay = 20

This was changed to 2ms in PG12. You should reduce that most likely.

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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Fwd: PG12 autovac issues
Следующее
От: stan
Дата:
Сообщение: Join help, please