Re: Need to find out which process is hitting hda

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "Ow Mun Heng" <Ow(dot)Mun(dot)Heng(at)wdc(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Need to find out which process is hitting hda
Date: 2007-12-13 17:03:18
Message-ID: dcc563d10712130903r72b52f63vc09fca27cb1fc868@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Dec 13, 2007 5:06 AM, Ow Mun Heng <Ow(dot)Mun(dot)Heng(at)wdc(dot)com> wrote:
> I'm using centos 5 as the OS so, there's no fancy dtrace to look at
> which processes is causing my disks to thrash.
>
> I have 4 disks in the box. (all ide, 7200rpm)
>
> 1 OS disk [hda]
> 2 raided (1) disks [hdb/hdc]
> 1 pg_xlog disk (and also used as an alternate tablespace for [hdd]
> temp/in-transit files via select, insert into tmp table. delete from tmp
> table, insert into footable select * from tmp table)
>
> the number of writes and reads on hda is much greater than expected and I'm not sure who/what is causing it.

Logging? just guessing. Or swapping. What's free say?

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Mark Wimer 2007-12-13 17:23:39 Re: SQL Query
Previous Message Erik Jones 2007-12-13 16:58:20 Re: autovacuum log?