Re: "pgstat wait timeout" warnings

Поиск
Список
Период
Сортировка
От Bernd Helmle
Тема Re: "pgstat wait timeout" warnings
Дата
Msg-id A876452AEBD3CC651D90ABAD@apophis.local
обсуждение исходный текст
Ответ на Re: "pgstat wait timeout" warnings  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Ответы Re: "pgstat wait timeout" warnings  (Andres Freund <andres@anarazel.de>)
Список pgsql-hackers

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

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


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Florian Pflug
Дата:
Сообщение: Re: XMLATTRIBUTES vs. values of type XML
Следующее
От: Andres Freund
Дата:
Сообщение: Re: "pgstat wait timeout" warnings