Re: Auto VACUUM

From: akp geek <akpgeek(at)gmail(dot)com>
To: Joao Ferreira gmail <joao(dot)miguel(dot)c(dot)ferreira(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Auto VACUUM
Date: 2010-03-05 15:35:40
Message-ID: 2024a9fb1003050735ldfdddbdq5d6ad3156b2876ed@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Chris Roffler 2010-03-05 16:22:48 XML performance tuning
Previous Message Joao Ferreira gmail 2010-03-05 15:35:35 Re: Auto VACUUM