Re: Getting "ERROR: canceling autovacuum task" - Mailing list pgsql-admin

From Alvaro Herrera
Subject Re: Getting "ERROR: canceling autovacuum task"
Date
Msg-id 20080210234756.GA7093@alvh.no-ip.org
Whole thread Raw
In response to Getting "ERROR: canceling autovacuum task"  ("Dean Gibson (DB Administrator)" <postgresql@ultimeth.com>)
List pgsql-admin
Dean Gibson (DB Administrator) wrote:
> I'm getting this loading some large (1 million row) tables.  Is this
> anything to be concerned about?

No, it's normal.  It means the autovacuum task was cancelled in order to
avoid blocking your regular Postgres sessions.

If it's only during table loading, there's no problem -- the table will
be processed later eventually.  If it happens all the time, I would
advise setting a cron job to carry out the vacuum task.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Postgres Backup and Restore
Next
From: "Phillip Smith"
Date:
Subject: Re: Postgres Backup and Restore