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
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
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