Re: Timeout error on pgstat

On 08/02/2012 04:27 AM, Anibal David Acosta wrote:
>
> I have a lot (maybe 1 every 10 seconds) of this error WARNING: pgstat
> wait timeout
>
A quick search suggests this can be due to excessive I/O. However, this
thread:

http://postgresql.1045698.n5.nabble.com/pgstat-wait-timeout-td5078125.html

sounds very similar to your issue. I'm wondering if there's a bug
lurking in there somewhere.

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

http://www.postgresql.org/docs/current/static/release-9-0-8.html

Consider updating. You don't need to do a dump and reload or use
pg_upgrade, since it's only a minor version update. Stop the DB, install
the new binaries, start the DB.

However, I don't see any fixes related to the stats writer in the
relnotes from the 9.0 series.

--
Craig Ringer