Re: temporarily stop autovacuum

--On Mittwoch, Februar 11, 2009 13:18:11 -0500 Robert Haas 
<robertmhaas@gmail.com> wrote:

> In any case it's not difficult to write a script that loops over all
> of your tables with ALTER TABLE.  It's probably not as fast as a
> single UPDATE statement, but I suspect you'd need to have an enormous
> number of tables for that to matter much.

Agreed, we often recommend this for all kinds of GRANTs, REVOKEs and so on. 
But while we don't have (yet) any facility to achieve this behavior with 
these commands, for autovacuum, a possible solution exists, and although a 
crude temporarily one, i know people seeing pg_autovacuum as a feature to 
do exactly this kind of maintenance.


--  Thanks
                   Bernd