Postgres Pro
Downloads
Home   >   mailing lists

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

From Jeff Janes
Subject Re: autovacuum big table taking hours and sometimes seconds
Date
Msg-id CAMkU=1ydp0oKTMNeQf7B4q2a3sQKBqnBVd+h7XTUs1fJHJAdag@mail.gmail.com
Whole thread Raw
In response to autovacuum big table taking hours and sometimes seconds  (Mariel Cherkassky <mariel.cherkassky@gmail.com>)
Responses Re: autovacuum big table taking hours and sometimes seconds  (Mariel Cherkassky <mariel.cherkassky@gmail.com>)
List pgsql-performance
Tree view
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: MichaelDBA
Date:
Subject: Re: autovacuum big table taking hours and sometimes seconds
Next
From: Mariel Cherkassky
Date:
Subject: Re: autovacuum big table taking hours and sometimes seconds