Re: autovacuum big table taking hours and sometimes seconds

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: Mariel Cherkassky <mariel(dot)cherkassky(at)gmail(dot)com>
Cc: pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: autovacuum big table taking hours and sometimes seconds
Date: 2019-02-06 14:12:43
Message-ID: CAMkU=1ydp0oKTMNeQf7B4q2a3sQKBqnBVd+h7XTUs1fJHJAdag@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Mariel Cherkassky 2019-02-06 14:42:24 Re: autovacuum big table taking hours and sometimes seconds
Previous Message MichaelDBA 2019-02-06 14:11:40 Re: autovacuum big table taking hours and sometimes seconds