Re: Auto VACUUM

Thanks for the help. Will do that.

Regards

On Fri, Mar 5, 2010 at 10:35 AM, Joao Ferreira gmail <
joao(dot)miguel(dot)c(dot)ferreira(at)gmail(dot)com> wrote:

> On Fri, 2010-03-05 at 10:03 -0500, akp geek wrote:
> > Hi All -
> >
> > I am still having the issue, even after I turned on the
> > auto vaccum. I have quick question. How do I know that auto vacuum
> > process is running. When I restarted my database , I got the message
> > auto vacuum launcher started. But is there a way that I can check that
> > the process is really working.
> >
>
> u can "tail -f <postgres-log-file>"
>
> in my case I have "tail -f /var/pgsql/data/logfile"
>
> in your case it could be diferent
>
> watch for lines containing the words "vacuum", "autovacuum", "will
> analyse" etc etc
>
> Joao
>
> >
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>