Re: temporarily stop autovacuum

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.