[PERFORM] Postgres 9.1.4 - high stats collector IO usage

2012-07-27 Thread David Barton
Hi, I am running postgres 9.1.4 on Ubuntu 12.04 and the stats collector is generating very high IO usage even when nothing appears to be happening on the system. I have roughly 150 different databases, each of which is running in 1 of roughly 30 tablespaces. The databases are small (the dum

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