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

From: Jens Wilke <jens(at)wilke(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Autovacuum firing up during my manual vacuum on same table
Date: 2011-04-04 19:49:24
Message-ID: 201104042149.28183.jens@wilke.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 3. April 2011, Joshua D. Drake 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.

Which cases?
Isn't it more like something else went suboptimal when starting to
think about manual vacuum?
May be i better had written that since 8.4 there's the opportunity
not to bother with manual vacuum any more.

Regards,
Jens

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Rob Sargent 2011-04-04 19:57:22 scary xpath_table behaviour
Previous Message Radosław Smogura 2011-04-04 19:44:03 Re: ..horribly documented, inefficient, user-hostile, impossible to maintain interpreted language..