Re: temporarily stop autovacuum - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: temporarily stop autovacuum
Date
Msg-id 20090210135335.GA3708@alvh.no-ip.org
Whole thread Raw
In response to temporarily stop autovacuum  (Tatsuo Ishii <ishii@postgresql.org>)
Responses Re: temporarily stop autovacuum  (Robert Haas <robertmhaas@gmail.com>)
Re: temporarily stop autovacuum  (ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp>)
List pgsql-hackers
Tatsuo Ishii wrote:
> Hi,
> 
> Is there any way to stop autovacuum temporarily?(other than edit
> postgresql.conf and reload it)

Hmm, no, that's the only way.

I'm not sure that this calls for a change in autovacuum itself; it seems
to be that whatwe really need is the ability to change postgresql.conf
settings from the SQL interface.  This has been discussed at length
elsewhere, and I think we need to bite the bullet eventually.


pgsql-hackers by date:

Previous
From: Euler Taveira de Oliveira
Date:
Subject: Re: [COMMITTERS] pgsql: Update autovacuum to use reloptions instead of a system catalog,
Next
From: Alvaro Herrera
Date:
Subject: Re: [COMMITTERS] pgsql: Update autovacuum to use reloptions instead of a system catalog,