| From: | "Ralph Mason" <ralph(dot)mason(at)telogis(dot)com> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Ever Increasing IOWAIT |
| Date: | 2007-05-17 22:45:29 |
| Message-ID: | 011b01c798d5$141365a0$3c3a30e0$@mason@telogis.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
We have a database running on a 4 processor machine. As time goes by the IO
gets worse and worse peeking at about 200% as the machine loads up.
The weird thing is that if we restart postgres it’s fine for hours but over
time it goes bad again.
(CPU usage graph here HYPERLINK
"http://www.flickr.com/photos/8347741(at)N02/502596262/"http://www.flickr.com/p
hotos/8347741(at)N02/502596262/ ) You can clearly see where the restart
happens in the IO area
This is Postgres 8.1.4 64bit.
Anyone have any ideas?
Thanks
Ralph
--
Internal Virus Database is out-of-date.
Checked by AVG Free Edition.
Version: 7.5.432 / Virus Database: 268.15.9/573 - Release Date: 5/12/2006
4:07 p.m.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2007-05-17 22:47:50 | Re: Automatic adjustment of bgwriter_lru_maxpages |
| Previous Message | Keaton Adams | 2007-05-17 16:01:34 | Re: WAL log performance/efficiency question |