Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id AC5D69FC1D3 for ; Thu, 17 May 2007 19:45:55 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 88318-02 for ; Thu, 17 May 2007 19:45:51 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from telogis.co.nz (telogis.co.nz [203.98.10.169]) by postgresql.org (Postfix) with ESMTP id 0DCF99FC1D8 for ; Thu, 17 May 2007 19:45:49 -0300 (ADT) Received: from RALPH2 ([::ffff:192.168.3.157]) by telogis.co.nz with esmtp; Fri, 18 May 2007 10:45:43 +1200 id 00978C09.464CDB1A.000014A2 From: "Ralph Mason" To: pgsql-performance@postgresql.org Subject: Ever Increasing IOWAIT Date: Fri, 18 May 2007 10:45:29 +1200 Message-ID: <011b01c798d5$141365a0$3c3a30e0$@mason@telogis.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_011C_01C79939.A94845A0" X-Mailer: Microsoft Office Outlook 12.0 Thread-Index: AceY1REWtM7va4ygQ++E2ZK6zSfPDA== Content-language: en-nz X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.344 tagged_above=0 required=5 tests=AWL=-0.576, BAYES_05=-1.11, HTML_MESSAGE=0.001, HTML_TEXT_AFTER_BODY=0.115, MSGID_MULTIPLE_AT=1.914 X-Spam-Level: X-Archive-Number: 200705/304 X-Sequence-Number: 24694 This is a multipart message in MIME format. ------=_NextPart_000_011C_01C79939.A94845A0 Content-Type: text/plain; charset="windows-1250" Content-Transfer-Encoding: quoted-printable 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. =20 The weird thing is that if we restart postgres it=92s fine for hours but = over time it goes bad again. =20 (CPU usage graph here HYPERLINK "http://www.flickr.com/photos/8347741@N02/502596262/"http://www.flickr.co= m/p hotos/8347741@N02/502596262/ ) You can clearly see where the restart happens in the IO area =20 This is Postgres 8.1.4 64bit. =20 Anyone have any ideas? =20 Thanks Ralph =20 --=20 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. =20 ------=_NextPart_000_011C_01C79939.A94845A0 Content-Type: text/html; charset="windows-1250" Content-Transfer-Encoding: quoted-printable

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 http://www.f= lickr.com/photos/8347741@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.

------=_NextPart_000_011C_01C79939.A94845A0--