Search Postgresql Archives

Re: Temporary disable autovacuum in pgsql 8.1.0

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Richard van den Berg <richard.vandenberg@xxxxxxxxxxxxxxxxx> writes:
> Tom Lane <tgl@xxxxxxxxxxxxx> 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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux