Re: Temporary disable autovacuum in pgsql 8.1.0 - Mailing list pgsql-general

From Tom Lane
Subject Re: Temporary disable autovacuum in pgsql 8.1.0
Date
Msg-id 286.1133881661@sss.pgh.pa.us
Whole thread Raw
In response to Re: Temporary disable autovacuum in pgsql 8.1.0  (Richard van den Berg <richard.vandenberg@trust-factory.com>)
Responses Re: Temporary disable autovacuum in pgsql 8.1.0
List pgsql-general
Richard van den Berg <richard.vandenberg@trust-factory.com> writes:
> 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.

That documentation is exactly correct.  Note that it doesn't say "can
only be set at server start" full stop.

            regards, tom lane

pgsql-general by date:

Previous
From: Richard van den Berg
Date:
Subject: Re: Temporary disable autovacuum in pgsql 8.1.0
Next
From: "Karthik.S"
Date:
Subject: error in creating database