On Thu, 15 Apr 2004, Cris Carampa wrote: > scott.marlowe wrote: > > > The current king of putting postgresql on multiple platters and getting > > best overall performance is a battery backed caching raid controller run > > one or more many disk RAID-5 arrays. > > I thought the best choice were RAID-10 (1+0) (when available). There > isn't a write penalty with RAID-5?
there is for software RAID-5 or for non-battery backed cached RAID-5, but for a battery backed controller, the penalty is basically gotten rid of by being hidden in a lazy write. Plus the controller can "gang" writes to individual drives to achieve a very good throughput. ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])