Re: "pgstat wait timeout" warnings

From: Bernd Helmle <mailings(at)oopsware(dot)de>
To: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: "pgstat wait timeout" warnings
Date: 2011-08-11 09:49:12
Message-ID: A876452AEBD3CC651D90ABAD@apophis.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

--On 10. August 2011 21:54:06 +0300 Heikki Linnakangas
<heikki(dot)linnakangas(at)enterprisedb(dot)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.

I've seen it on customer instances with very high INSERT peak loads (several
dozens backends INSERTing/UPDATEing data concurrently). We are using a RAM disk
for stats_temp_directory now for a while, and the timeout never occured again.

--
Thanks

Bernd

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2011-08-11 10:03:52 Re: "pgstat wait timeout" warnings
Previous Message Florian Pflug 2011-08-11 09:12:51 Re: XMLATTRIBUTES vs. values of type XML