Re: autovacuum big table taking hours and sometimes seconds

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: autovacuum big table taking hours and sometimes seconds
Дата
Msg-id CAMkU=1ydp0oKTMNeQf7B4q2a3sQKBqnBVd+h7XTUs1fJHJAdag@mail.gmail.com
обсуждение исходный текст
Ответ на autovacuum big table taking hours and sometimes seconds  (Mariel Cherkassky <mariel.cherkassky@gmail.com>)
Ответы Re: autovacuum big table taking hours and sometimes seconds
Список pgsql-performance
Дерево обсуждения
On Wed, Feb 6, 2019 at 5:29 AM Mariel Cherkassky <mariel.cherkassky@gmail.com> wrote:
 
Now the question is how to handle or tune it ? Is there any change that I need to increase the cost_limit / cost_delay ?

Sometimes vacuum has more work to do, so it takes more time to do it.

There is no indication of a problem. Or at least, you haven't described one. So, there is nothing to handle or to tune.

If there is a problem, those log entries might help identify it.  But in the absence of a problem, they are just log spam.

Cheers,

Jeff

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

Предыдущее
От: MichaelDBA
Дата:
Сообщение: Re: autovacuum big table taking hours and sometimes seconds
Следующее
От: Mariel Cherkassky
Дата:
Сообщение: Re: autovacuum big table taking hours and sometimes seconds