Re: "pgstat wait timeout" warnings - Mailing list pgsql-hackers

From Tom Lane
Subject Re: "pgstat wait timeout" warnings
Date
Msg-id 23623.1313073011@sss.pgh.pa.us
Whole thread Raw
In response to Re: "pgstat wait timeout" warnings  (Andres Freund <andres@anarazel.de>)
Responses Re: "pgstat wait timeout" warnings
List pgsql-hackers
Andres Freund <andres@anarazel.de> writes:
>> --On 10. August 2011 21:54:06 +0300 Heikki Linnakangas
>> <heikki.linnakangas@enterprisedb.com> wrote:
>>> So my theory is that if the I/O is really busy, write() on the stats file
>>> blocks for more than 5 seconds, and you get the timeout.

> Yes, I have seen it several times as well. I can actually reproduce it
> without much problems, so if you have some idea to test...

It doesn't surprise me that it's possible to reproduce it under extreme
I/O load.  What I am wondering about is whether there's some bug/effect
that allows it to happen without that.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: compiling 9.2 : WinXp+mingw
Next
From: Robert Haas
Date:
Subject: Re: "pgstat wait timeout" warnings