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
|
| Список | 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 по дате отправления: