Re: temporarily stop autovacuum - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: temporarily stop autovacuum
Date
Msg-id 20090211172152.GH8924@alvh.no-ip.org
Whole thread Raw
In response to Re: temporarily stop autovacuum  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: temporarily stop autovacuum  ("Joshua D. Drake" <jd@commandprompt.com>)
Re: temporarily stop autovacuum  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Peter Eisentraut wrote:
> Joshua D. Drake wrote:

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

Hmm, argh.  Maybe we do need the rule on a fake pg_autovacuum that
Itagaki-san was proposing.

There's a problem however; for pg_autovacuum you used to need to insert
some -1 values on columns on which you wanted to keep as defaults.  On
the new code you need to skip the value altogether, and a -1 is rejected
with an error.  Not sure how would we translate that.



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: advance local xmin more aggressively
Next
From: Tom Lane
Date:
Subject: Re: Optimization rules for semi and anti joins