On Dec 13, 2007 5:06 AM, Ow Mun Heng <Ow.Mun.Heng@xxxxxxx> 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?
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
