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. Joshua D. Drake > -- > Tatsuo Ishii > SRA OSS, Inc. Japan > -- PostgreSQL - XMPP: jdr...@jabber.postgresql.org Consulting, Development, Support, Training 503-667-4564 - http://www.commandprompt.com/ The PostgreSQL Company, serving since 1997 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers