On 8/16/07, tyrrill_ed@xxxxxxx <tyrrill_ed@xxxxxxx> wrote: > > > Hi Miki, > > I am using a Dell 2950, and I recently switched from using RAID 5 of all six > disks to three RAID 1 pairs with the OS on the first pair, postgres on the > second except for pg_xlog, which I moved to the third pair. This > configuration change increased the insert performance of my application by > 40%. I have not tried RAID 10 so I cannot help you there. My suggestion is > test both RAID 5 and RAID 10, and report back to us what you find. Good to know. Also, be aware that one some RAID controllers, you'll get better performance if you make the mirrors on the RAID controller, then RAID 0 them in the OS / Kernel. RAID 0 is very low on overhead, so it doesn't have much negative impact on the server anyway. We have a re-purposed Dell 4600 workstation with a single CPU and 2 Gigs ram with a 4 disk linux kernel software RAID-10 that's quite a bit faster at most db work than the 2850 w/ dual CPUs, 4 gigs ram, and a perc 5 series controller w/ battery backed cache and a 4 disk RAID-5 it is complementing. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
