Re: Working happily on 8.1 (Was: panic on 7.3) - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Working happily on 8.1 (Was: panic on 7.3)
Date
Msg-id 18862.1137868969@sss.pgh.pa.us
Whole thread Raw
In response to Re: Working happily on 8.1 (Was: panic on 7.3)  (Rick Gigger <rick@alpinenetworking.com>)
List pgsql-hackers
Rick Gigger <rick@alpinenetworking.com> writes:
>> By default, autovacuum isn't even turned on --- you have to enable it
>> and also stats_row_level if you want to use autovac.  I don't have
>> enough experience with it to say whether the other settings are
>> adequate.

> Yes, I realized this not long after I started things up, so I will  
> have to wait till a time when I can restart postgres to try it out.   

As long as you left stats_start_collector on, that's not so.  autovacuum
and stats_row_level can both be changed without a postmaster restart;
just fix the config file and SIGHUP.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Rod Taylor
Date:
Subject: Re: Commands per transaction
Next
From: Tom Lane
Date:
Subject: Re: Commands per transaction