Thread: Getting "ERROR: canceling autovacuum task"

Getting "ERROR: canceling autovacuum task"

From
"Dean Gibson (DB Administrator)"
Date:
I'm getting this loading some large (1 million row) tables.  Is this
anything to be concerned about?

Re: Getting "ERROR: canceling autovacuum task"

From
Alvaro Herrera
Date:
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.