Re: Timeout error on pgstat

[Craig Ringer <ringerc@xxxxxxxxxxxxx>]

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