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.
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers