Re: 8.2.3 AutoVacuum not running

"Schwenker, Stephen" <SSchwenker(at)thestar(dot)ca> writes:
> It says it's on and I have also turned on all stats collecting.

My guess is that it's actually running but is not choosing to do any
vacuums for some reason. Try setting log_min_messages to DEBUG5 for
awhile and trawling the postmaster log for evidence. You should at
minimum see messages indicating that the postmaster is launching an
autovac worker process once a minute; the next question is what that
process is doing with itself. (You might want to adjust log_line_prefix
to include PID so that you can track which messages come from which
process. I find including a timestamp is often helpful also.)

regards, tom lane