Re: why is autovacuum still ongoing even if set to off ? - Mailing list pgsql-general

From Scott Marlowe
Subject Re: why is autovacuum still ongoing even if set to off ?
Date
Msg-id dcc563d10907302341w731c6fe9uc430c56cad3f2793@mail.gmail.com
Whole thread Raw
In response to Re: why is autovacuum still ongoing even if set to off ?  (Costin Grigoras <costing@gmail.com>)
List pgsql-general
On Fri, Jul 31, 2009 at 12:24 AM, Costin Grigoras<costing@gmail.com> wrote:
>
>> Anytime autovacuum is instrusive look at incrementing the nap time to
>> 10 to 20 ms.  If that doesn't help then you're already running on the
>> ragged edge of IO throughput and might need to look into a faster RAID
>> array or something.
>>
>
> => show autovacuum_naptime;
> autovacuum_naptime
> --------------------
> 100h

Dangit, I meant cost delay...  urg.  That's a really long naptime, but
since you vacuum anyway it shouldn't matter.

So, after disabling autovacuum in postgresql.conf, you reloaded /
restart postgresql, right?

pgsql-general by date:

Previous
From: Costin Grigoras
Date:
Subject: Re: why is autovacuum still ongoing even if set to off ?
Next
From: Scott Marlowe
Date:
Subject: Re: why is autovacuum still ongoing even if set to off ?