From: Jignesh K. Shah <J.K.Shah@Sun.COM>
To: Junaili Lie <junaili@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: slow i/o
Date: Tue, 29 Aug 2006 16:10:56 +0100
Message-ID: <44F45900.4000702@sun.com> (raw)
In-Reply-To: <8d04ce990608281606r153ed796xcf5d9d3a44d8e632@mail.gmail.com>
References: <8d04ce990608281606r153ed796xcf5d9d3a44d8e632@mail.gmail.com>
Also to answer your real question:
DTrace On Solaris 10:
# dtrace -s /usr/demo/dtrace/whoio.d
It will tell you the pids doing the io activity and on which devices.
There are more scripts in that directory like iosnoop.d, iotime.d and others which also will give
other details like file accessed, time it took for the io etc.
Hope this helps.
Regards,
Jignesh
Junaili Lie wrote:
> 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
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: J.K.Shah@Sun.COM, junaili@gmail.com
Subject: Re: slow i/o
In-Reply-To: <44F45900.4000702@sun.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox