Tom Lane <tgl@sss.pgh.pa.us> wrote on 06-12-2005 15:49:28: > Couldn't you have just set autovacuum = off in postgresql.conf? (Unlike > some other things, this setting can be changed after postmaster start.)
If that is true, the documentation at http://www.postgresql.org/docs/8.1/static/runtime-config-autovacuum.html should be updated:
autovacuum (boolean) Controls whether the server should start the autovacuum subprocess. This is off by default. stats_start_collector and stats_row_level must also be on for this to start. This option can only be set at server start or in the postgresql.conf file.
Richard van den Berg, CISSP ------------------------------------------- Trust Factory B.V. | www.dna-portal.net Bazarstraat 44a | www.trust-factory.com 2518AK The Hague | Phone: +31 70 3620684 The Netherlands | Fax : +31 70 3603009 -------------------------------------------