Also, I have heard a lot of people reocommending RAID 0+1 or 1+0 as a good mix of reliability and performance.
--------------------------------------------------------------------------- Curt Sampson wrote: > On Thu, 23 Jan 2003, David Kennedy wrote: > > > This weekend I will be building a couple of new postgres database servers > > under RH7.3, and I am currently deciding between 2 different configuration > > options. The new servers feature hot-swappable RAID w/ 3 hard drives in > > each. > > It depends on what you need in terms of reliability and performance. > > Best performance (assuming non-insignifcant write load): > > Put the OS and DB on the first two drives, striped (RAID0), and the > logs on the third drive. > > Best safety maximum capacity: > > Put everything on a single RAID5 across all three drives. (RAID5 on > three drives is likely to be significantly slower than a single disk > or mirrored pair would be, though.) > > Best safety with good performance: > > Mirror two drives (RAID1) and put everything on the pair. Use the > third drive as a hot spare for the mirrored pair. > > cjs > -- > Curt Sampson <[EMAIL PROTECTED]> +81 90 7737 2974 http://www.netbsd.org > Don't you know, in this new Dark Age, we're all light. --XTC > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED]) > -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
