Re: temporarily stop autovacuum - Mailing list pgsql-hackers

From Joshua D. Drake
Subject Re: temporarily stop autovacuum
Date
Msg-id 1234230498.6517.105.camel@jd-laptop.pragmaticzealot.org
Whole thread Raw
In response to temporarily stop autovacuum  (Tatsuo Ishii <ishii@postgresql.org>)
Responses Re: temporarily stop autovacuum  (Tatsuo Ishii <ishii@postgresql.org>)
Re: temporarily stop autovacuum  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
On Tue, 2009-02-10 at 10:15 +0900, Tatsuo Ishii wrote:
> Hi,
> 
> Is there any way to stop autovacuum temporarily?(other than edit
> postgresql.conf and reload it) Pgpool-II does not want autovacuum
> running while doing "onlie recovery".

It would be a significant hack but you could update pg_autovacuum to set
all relations to false.

Joshua D. Drake


> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> 
-- 
PostgreSQL - XMPP: jdrake@jabber.postgresql.org  Consulting, Development, Support, Training  503-667-4564 -
http://www.commandprompt.com/ The PostgreSQL Company, serving since 1997
 



pgsql-hackers by date:

Previous
From: Tatsuo Ishii
Date:
Subject: temporarily stop autovacuum
Next
From: Tatsuo Ishii
Date:
Subject: Re: temporarily stop autovacuum