Re: Auto VACUUM - Mailing list pgsql-general

From Joshua D. Drake
Subject Re: Auto VACUUM
Date
Msg-id 1267720453.27895.827.camel@jd-desktop.iso-8859-1.charter.com
Whole thread Raw
In response to Re: Auto VACUUM  (akp geek <akpgeek@gmail.com>)
List pgsql-general
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.


pgsql-general by date:

Previous
From: "Dann Corbit"
Date:
Subject: Re: Optimal database table optimization method
Next
From: "Wang, Mary Y"
Date:
Subject: Restore Data Encountered the ERROR: literal carriage return found in data Error