| From: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
| Cc: | "Henry C(dot)" <henka(at)cityweb(dot)co(dot)za>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Autovacuum firing up during my manual vacuum on same table |
| Date: | 2011-04-03 21:19:59 |
| Message-ID: | BANLkTinsG8sAEr3As+Y0rKu6gV9XEOH_JA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Sun, Apr 3, 2011 at 2:39 PM, Joshua D. Drake <jd(at)commandprompt(dot)com> wrote:
> On Sat, 2 Apr 2011 19:26:56 +0200, "Henry C." <henka(at)cityweb(dot)co(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Annamalai Gurusami | 2011-04-04 04:43:02 | Re: Merged Model for libpq |
| Previous Message | Joshua D. Drake | 2011-04-03 20:39:46 | Re: Autovacuum firing up during my manual vacuum on same table |