slow i/o - Mailing list pgsql-performance

From Junaili Lie
Subject slow i/o
Date
Msg-id 8d04ce990608281606r153ed796xcf5d9d3a44d8e632@mail.gmail.com
Whole thread Raw
Responses Re: slow i/o  ("Jignesh K. Shah" <J.K.Shah@Sun.COM>)
Re: slow i/o  ("Jignesh K. Shah" <J.K.Shah@Sun.COM>)
List pgsql-performance
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

pgsql-performance by date:

Previous
From: "Merlin Moncure"
Date:
Subject: Re: Postgre SQL 7.1 cygwin performance issue.
Next
From: "Peter Childs"
Date:
Subject: Re: Identifying bloated tables