From: | Таир Сабыргалиев <tair(dot)sabirgaliev(at)bee(dot)kz> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | WARNING: pgstat wait timeout |
Date: | 2011-11-02 18:05:58 |
Message-ID: | CAGHMyQ3TwhSv+S7YiH04mvx-HFV7ykfvt3H=vgx-fbL6XOJ+nA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hi all!
First of all thank you for this awesome database! We are successfully using
PG on top of Linux
in our projects for 2 years so far and are very happy with the performance
and observability
features of the database.
Recently we deployed PG 9.0.5-x64 on Windows Server 2008 R2 and noticed
very strange behavior:
at some time after firing up the DB it starts logging many 'pgstat wait
timeout' messages.
We monitor the IO, and it never goes higher than 10MB/s, whereas the total
throughput of DB disks is ~200MB/s.
I wouldn't bother, but the performance degrades soon after the message
starts showing up.
After some digging around I found that the reason is that
$PGDATA/pg_stat_tmp/pgstat.stat stops updating.
The workaround for me was to SIGHUP the DB -- pgstat.stat starts updating
and the warning stops.
Is this expected behavior?
If this is a bug what information will be helpful in this particular
situation to include in the bug-report?
Thanks!
--
Tair Sabirgaliev
From | Date | Subject | |
---|---|---|---|
Next Message | Jean-Yves F. Barbier | 2011-11-02 19:07:29 | Re: WARNING: pgstat wait timeout |
Previous Message | Andreas Kretschmer | 2011-10-31 16:29:01 | Re: execute sql-script several times |