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

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.

>
> Sadly, in my case, the db is so busy that autovac processes run for
weeks
> and
> never catch up (insufficient h/w for the app quite frankly - the
addition
> of

You can disable autovacuum for the relations that you are manually
vacuuming. If pre 8.4 see pg_autovacuum, if post see alter table.

JD

--
PostgreSQL - XMPP: jdrake(at)jabber(dot)postgresql(dot)org
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving since 1997