Re: why is autovacuum still ongoing even if set to off ?

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: why is autovacuum still ongoing even if set to off ?
Дата
Msg-id dcc563d10907302341w731c6fe9uc430c56cad3f2793@mail.gmail.com
обсуждение исходный текст
Ответ на Re: why is autovacuum still ongoing even if set to off ?  (Costin Grigoras <costing@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Costin Grigoras
Дата:
Сообщение: Re: why is autovacuum still ongoing even if set to off ?
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: why is autovacuum still ongoing even if set to off ?