Re: temporarily stop autovacuum

On Wed, 2009-02-11 at 14:21 -0300, Alvaro Herrera wrote:
> 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.

I got plenty of complaints that aren't being fixed :). pg_dump doesn't
even know how to deal with pg_autovacuum, changing scripts to handle
their autovacuum modifications won't take much.

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

I don't think so. A clean cut is the way to go.

Sincerely,

Joshua D. Drake
-- 
PostgreSQL - XMPP: jdrake@jabber.postgresql.org  Consulting, Development, Support, Training  503-667-4564 -
http://www.commandprompt.com/ The PostgreSQL Company, serving since 1997