Re: temporarily stop autovacuum

Joshua D. Drake wrote:
> 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.

Which will no longer work in 8.4.

More generally, it was pointed out to me that users apparently do 
updates of pg_autovacuum to change settings on a bunch of tables at 
once.  We might get some complaints if we remove that facility.