Re: temporarily stop autovacuum

From: Tatsuo Ishii <ishii(at)postgresql(dot)org>
To: jd(at)commandprompt(dot)com
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: temporarily stop autovacuum
Date: 2009-02-10 01:50:27
Message-ID: 20090210.105027.02302179.t-ishii@sraoss.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> > 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.

Thanks. Maybe it will be easier to talk to the autovacuum launcher
daemon process directly? I will look in to the code.
--
Tatsuo Ishii
SRA OSS, Inc. Japan

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message KaiGai Kohei 2009-02-10 01:53:41 Updates of SE-PostgreSQL 8.4devel patches (r1530)
Previous Message Joshua D. Drake 2009-02-10 01:48:18 Re: temporarily stop autovacuum