X-Original-To: pgsql-performance-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 4EAED9FD2D2 for ; Mon, 28 Aug 2006 20:06:55 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 37304-08 for ; Mon, 28 Aug 2006 23:06:52 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.169]) by postgresql.org (Postfix) with ESMTP id EA48D9FD2D0 for ; Mon, 28 Aug 2006 20:06:51 -0300 (ADT) Received: by ug-out-1314.google.com with SMTP id m3so1776500ugc for ; Mon, 28 Aug 2006 16:06:50 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type; b=SlZp50iBgqDXPHwGUTXoFoBuhJ6hnzM0HhcBWcxDHwjAmV38L6qKWcw1D6SB3F52xH5tcM+OF3rEPKF/sH3WEvQqrn2rHM359/LKviC8PtnlVgTbUFP8M7BGnMohOWYLnZ5D8et6lhfXfENjlae0qnEAdMCuOBRmIqcqGzzRDgw= Received: by 10.66.220.17 with SMTP id s17mr4061823ugg; Mon, 28 Aug 2006 16:06:50 -0700 (PDT) Received: by 10.67.31.16 with HTTP; Mon, 28 Aug 2006 16:06:50 -0700 (PDT) Message-ID: <8d04ce990608281606r153ed796xcf5d9d3a44d8e632@mail.gmail.com> Date: Mon, 28 Aug 2006 16:06:50 -0700 From: "Junaili Lie" To: pgsql-performance@postgresql.org Subject: slow i/o MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_30480_31795423.1156806410252" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.995 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE, HTML_00_10, HTML_MESSAGE, SPF_PASS X-Spam-Level: X-Archive-Number: 200608/449 X-Sequence-Number: 20634 ------=_Part_30480_31795423.1156806410252 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Hi everyone, We have a postgresql 8.1 installed on Solaris 10. It is running fine. However, for the past couple days, we have seen the i/o reports indicating that the i/o is busy most of the time. Before this, we only saw i/o being busy occasionally (very rare). So far, there has been no performance complaints by customers, and the slow query reports doesn't indicate anything out of the ordinary. There's no code changes on the applications layer and no database configuration changes. I am wondering if there's a tool out there on Solaris to tell which process is doing most of the i/o activity? Thank you in advance. J ------=_Part_30480_31795423.1156806410252 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Hi everyone,
We have a postgresql 8.1 installed on Solaris 10. It is running fine. However, for the past couple days, we have seen the i/o reports indicating that the i/o is busy most of the time. Before this, we only saw i/o being busy occasionally (very rare). So far, there has been no performance complaints by customers, and the slow query reports doesn't indicate anything out of the ordinary.
There's no code changes on the applications layer and no database configuration changes.
I am wondering if there's a tool out there on Solaris to tell which process is doing most of the i/o activity?
Thank you in advance.

J

------=_Part_30480_31795423.1156806410252--