Re: Working happily on 8.1 (Was: panic on 7.3)

Rick Gigger <rick(at)alpinenetworking(dot)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