Re: [PERFORM] pgstat wait timeout

2012-07-27 Thread Anibal David Acosta
More information. After many "WARNING: pgstat wait timeout" in the log also appear "ERROR: canceling autovacuum task " De: Anibal David Acosta [mailto:a...@devshock.com] Enviado el: viernes, 27 de julio de 2012 06:04 p.m. Para: pgsql-performance@postgresql.org Asunto: pgstat wai

[PERFORM] pgstat wait timeout

2012-07-27 Thread Anibal David Acosta
In my postgres log I saw a lot of warning like this. WARNING: pgstat wait timeout Every 10 seconds aprox since yesterday and after one year working without any warning I have postgres 9.0.3 on a Windows Server 2008 R2. I have only one big table with aprox. 1,300,000,000 (yes 1,300