| 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: | Whole Thread | Raw Message | 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?
| 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? |