Stephane Tessier wrote:
I checked and we have a 128 megs battery backed cache on the raid controller...
we have space for more ram(we use 2 gigs on possibility of 3 gigs) iowait is very high 98% --> look like postgresql wait for io access raid5 -->raid0 if i'm right raid5 use 4 writes(parity,data, etc) for each write on disk
Just get battery backed cache on your RAID controller. RAID0 is way too unreliable for a production environment. One disk dies and all your data is just gone.
I'm the one who sent the e-mail about RAID 5's 4 writes, but I suggested you look at RAID 10, not RAID 0.
--
James Thornton ______________________________________________________ Internet Business Consultant, http://jamesthornton.com
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend