"Schwenker, Stephen" <SSchwenker@thestar.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