| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | "Dean Gibson (DB Administrator)" <postgresql(at)ultimeth(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Getting "ERROR: canceling autovacuum task" |
| Date: | 2008-02-10 23:47:56 |
| Message-ID: | 20080210234756.GA7093@alvh.no-ip.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Phillip Smith | 2008-02-10 23:56:55 | Re: Postgres Backup and Restore |
| Previous Message | Tom Lane | 2008-02-10 23:40:21 | Re: Postgres Backup and Restore |