> > 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.
Thanks. Maybe it will be easier to talk to the autovacuum launcher daemon process directly? I will look in to the code. -- Tatsuo Ishii SRA OSS, Inc. Japan -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers