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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
