Обсуждение: Getting "ERROR: canceling autovacuum task"

Поиск
Список
Период
Сортировка

Getting "ERROR: canceling autovacuum task"

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

Re: Getting "ERROR: canceling autovacuum task"

От
Alvaro Herrera
Дата:
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.