Re: autovacuum big table taking hours and sometimes seconds

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(dot)janes(at)gmail(dot)com‬‏>:‬

> On Wed, Feb 6, 2019 at 5:29 AM Mariel Cherkassky <
> mariel(dot)cherkassky(at)gmail(dot)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
>