Re: autovacuum not running

[Ben <bench(at)silentmedia(dot)com>]

Hm, I assumed it wasn't running because pg_stat_all_tables shows the last
vacuum from several weeks ago, and this is an active db. Also, I see no 
vacuum activity in the logs. But "show autovacuum" does show it being 
on....

So if it is running after all, how can I track down why things aren't 
getting vacuumed? What log level are the autovacuum logs at?

On Tue, 28 Aug 2007, Alvaro Herrera wrote:

> Ben wrote:
> > My autovacuum daemon isn't running on 8.2.4, and I'm guessing it's because
> > I changed my unix socket directory in postgresql.conf. Is there a way I can
> > tell autovacuum which socket file to use, or which IP to connect to?
>
> It doesn't use a socket.  How do you know it's not running?  An easy
> test is connect with psql and do a "show autovacuum".  If it's on, then
> it is running.
>
> --
> Alvaro Herrera                 http://www.amazon.com/gp/registry/CTMLCN8V17R4
> "El número de instalaciones de UNIX se ha elevado a 10,
> y se espera que este número aumente" (UPM, 1972)