Re: autovacuum big table taking hours and sometimes seconds

Поиск
Список
Период
Сортировка
От Mariel Cherkassky
Тема Re: autovacuum big table taking hours and sometimes seconds
Дата
Msg-id CA+t6e1nKxAutAs2RzugZ4EvFXDY2LCaZBBshMLrVgrW+0i8E=A@mail.gmail.com
обсуждение исходный текст
Ответ на Re: autovacuum big table taking hours and sometimes seconds  (Jeff Janes <jeff.janes@gmail.com>)
Ответы Re: autovacuum big table taking hours and sometimes seconds  (Jeff Janes <jeff.janes@gmail.com>)
Список pgsql-performance
Дерево обсуждения
Well, basically I'm trying to tune it because the table still keep growing. I thought that by setting the scale and the threshold it will be enough but its seems that it wasnt. I attached some of the logs output to hear what you guys think about it ..

‫בתאריך יום ד׳, 6 בפבר׳ 2019 ב-16:12 מאת ‪Jeff Janes‬‏ <‪jeff.janes@gmail.com‬‏>:‬
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 по дате отправления:

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