Re: Autovacuum firing up during my manual vacuum on same table

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: Autovacuum firing up during my manual vacuum on same table
Дата
Msg-id BANLkTinsG8sAEr3As+Y0rKu6gV9XEOH_JA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Autovacuum firing up during my manual vacuum on same table  ("Joshua D. Drake" <jd@commandprompt.com>)
Список pgsql-general
On Sun, Apr 3, 2011 at 2:39 PM, Joshua D. Drake <jd@commandprompt.com> wrote:
> On Sat, 2 Apr 2011 19:26:56 +0200, "Henry C." <henka@cityweb.co.za> wrote:
>> On Sat, April 2, 2011 14:17, Jens Wilke wrote:
>>> Nevertheless since at least 8.4 IMO there's no need to bother with
>>> manual vacuum any more.
>
> Uhh, this is entirely untrue. There are plenty of cases where 8.4
> autovacuum can't cut it.

This is doubly true if you haven't adjusted any of the default costing
parameters of autovacuum. It is not set to the level of aggressiveness
needed for big servers under high load, since doing so would slow down
/ swamp smaller servers.

В списке pgsql-general по дате отправления:

Предыдущее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: Autovacuum firing up during my manual vacuum on same table
Следующее
От: Annamalai Gurusami
Дата:
Сообщение: Re: Merged Model for libpq