Richard van den Berg <[EMAIL PROTECTED]> writes: > Tom Lane <[EMAIL PROTECTED]> 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. That documentation is exactly correct. Note that it doesn't say "can only be set at server start" full stop. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster