Re: Auto VACUUM

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.

I have not been getting any error messages like the one I used
to get
ERROR: canceling autovacuum task with table name

Can you please share your thoughts?

Regards

On Thu, Mar 4, 2010 at 11:34 AM, Joshua D. Drake <jd(at)commandprompt(dot)com>wrote:

> On Thu, 2010-03-04 at 11:04 -0500, akp geek wrote:
> > My RAM size is 8GB. I have set the maintenance_work_mem = 500MB this
> > morning.
> >
> > ERROR: canceling autovacuum task with table name
> >
> > Thanks for the help
>
> You likely have a lock that is conflicting with autovacuum and it
> cancels itself to not conflict.
>
> Joshua D. Drake
>
>
>
> --
> PostgreSQL.org Major Contributor
> Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564
> Consulting, Training, Support, Custom Development, Engineering
> Respect is earned, not gained through arbitrary and repetitive use or Mr.
> or Sir.
>
>