Re: Getting "ERROR: canceling autovacuum task"

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: Getting "ERROR: canceling autovacuum task"
Дата
Msg-id 20080210234756.GA7093@alvh.no-ip.org
обсуждение исходный текст
Ответ на Getting "ERROR: canceling autovacuum task"  ("Dean Gibson (DB Administrator)" <postgresql@ultimeth.com>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Postgres Backup and Restore
Следующее
От: "Phillip Smith"
Дата:
Сообщение: Re: Postgres Backup and Restore