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. ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
