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