Craig, those lines appear between pgstat timeout ERROR: canceling autovacuum task CONTEXT: automatic vacuum of table "XXX" The table XXX is a table with about 200 insert p/ second. No update or delete. The problem apparently is just with this table because there are others autovacuum running and working fin over others tables The only difference is that this table XXX has about 5millions of insert daily and all those 5millons are deleted in the night (cleanup process). De: Craig Ringer [mailto:ringerc@xxxxxxxxxxxxx] On 08/02/2012 04:27 AM, Anibal David Acosta wrote:
A quick search suggests this can be due to excessive I/O. However, this thread: In the pg_stat_activity show an autovacuum process over a very used table that runs about 1 hour and then this vacuum is cancelled (according to log) Was there any context to the `cancelling autovacuum task' message? I have Postgres 9.0.3 on a windows 2008 R2 running for about 1 year in same conditions, but this error is occurring about 1 week ago. The current 9.0 release is 9.0.8, so you're missing a bunch of bug fixes. |
