Erik Aronesty <erik@q32.com> writes:
> I think, perhaps, autovac wasn't running on that machine.
> Is there any way to check to see if it's running?
> I have enabled all the options , and I know it's running on my other
> servers because I see
> LOG: autovacuum.... entries (a profusion of them)
> I suspect, perhaps, that it's just not showing up in the log since my
> 8.2 BSD box came with different settings by default.
8.2 has far crummier support for logging what autovacuum is doing than
8.3 does :-(. The settings you show should mean that it's running, but
the only way to check specifically is to crank log_min_messages way up,
which will clutter your log with a lot of useless noise along with
autovacuum's messages.
regards, tom lane