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

From Richard van den Berg
Subject Re: Temporary disable autovacuum in pgsql 8.1.0
Date
Msg-id OFD5940109.C75F5DE3-ONC12570CF.00525C17-C12570CF.005284BE@trust-factory.com
Whole thread Raw
In response to Re: Temporary disable autovacuum in pgsql 8.1.0  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Temporary disable autovacuum in pgsql 8.1.0
List pgsql-general

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
-------------------------------------------

pgsql-general by date:

Previous
From: "Markus Wollny"
Date:
Subject: Re: Unicode Corruption and upgrading to 8.0.4. to 8.1
Next
From: Tom Lane
Date:
Subject: Re: Temporary disable autovacuum in pgsql 8.1.0