| From: | Richard van den Berg <richard(dot)vandenberg(at)trust-factory(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Temporary disable autovacuum in pgsql 8.1.0 |
| Date: | 2005-12-06 15:01:18 |
| Message-ID: | OFD5940109.C75F5DE3-ONC12570CF.00525C17-C12570CF.005284BE@trust-factory.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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
-------------------------------------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-12-06 15:07:41 | Re: Temporary disable autovacuum in pgsql 8.1.0 |
| Previous Message | Markus Wollny | 2005-12-06 14:54:27 | Re: Unicode Corruption and upgrading to 8.0.4. to 8.1 |