Re: Postgres becoming slow, only full vacuum fixes it

Поиск
Список
Период
Сортировка
От Kiriakos Tsourapas
Тема Re: Postgres becoming slow, only full vacuum fixes it
Дата
Msg-id 5526E5B0-DDCD-4D47-91B7-B3D4CA11A83E@gmail.com
обсуждение исходный текст
Ответ на Re: Postgres becoming slow, only full vacuum fixes it  (Kiriakos Tsourapas <ktsour@gmail.com>)
Ответы Re: Postgres becoming slow, only full vacuum fixes it  (Kiriakos Tsourapas <ktsour@gmail.com>)
Список pgsql-performance
Dear all,

Just letting you know that making the autovacuum policy more aggressive seems to have fixed the problem.
It's been 4 days now and everything is running smoothly.

Just a reminder, what I changed was :
autovacuum_vacuum_scale_factor = 0.01
autovacuum_analyze_scale_factor = 0.005
making autovacuum run at 1% instead of 20% (the dafault) and the analyze run at 0,5% instead of 10%.

Maybe it's more aggressive than needed... I will monitor and post back.


Thank you all for your help.

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

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: hardware advice
Следующее
От: Jeremy Harris
Дата:
Сообщение: Re: hardware advice