Re: Autovacuum firing up during my manual vacuum on same table - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Autovacuum firing up during my manual vacuum on same table
Date
Msg-id BANLkTinsG8sAEr3As+Y0rKu6gV9XEOH_JA@mail.gmail.com
Whole thread Raw
In response to Re: Autovacuum firing up during my manual vacuum on same table  ("Joshua D. Drake" <jd@commandprompt.com>)
List 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 by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Autovacuum firing up during my manual vacuum on same table
Next
From: Annamalai Gurusami
Date:
Subject: Re: Merged Model for libpq