Postgres Pro
Downloads
Home   >   mailing lists

Re: autovacuum big table taking hours and sometimes seconds - Mailing list pgsql-performance

From Mariel Cherkassky
Subject Re: autovacuum big table taking hours and sometimes seconds
Date
Msg-id CA+t6e1nKxAutAs2RzugZ4EvFXDY2LCaZBBshMLrVgrW+0i8E=A@mail.gmail.com
Whole thread Raw
In response to Re: autovacuum big table taking hours and sometimes seconds  (Jeff Janes <jeff.janes@gmail.com>)
Responses Re: autovacuum big table taking hours and sometimes seconds
List pgsql-performance
Tree view
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 by date:

Previous
From: Jeff Janes
Date:
Subject: Re: autovacuum big table taking hours and sometimes seconds
Next
From: Jeff Janes
Date:
Subject: Re: autovacuum big table taking hours and sometimes seconds