For any database, anywhere, the answer is pretty much always RAID-10.
The only time you would do anything else is for odd special cases.
Cheers
Dave
On Sun, Feb 13, 2011 at 2:12 PM, sergey
<sergey.on.net@gmail.com> wrote:
Hello,
I got a disk array appliance of 8 disks 1T each (UltraStor RS8IP4). It will be used solely by PostgresQL database and I am trying to choose the best RAID level for it.
The most priority is for read performance since we operate large data sets (tables, indexes) and we do lots of searches/scans, joins and nested queries. With the old disks that we have now the most slowdowns happen on SELECTs.
Fault tolerance is less important, it can be 1 or 2 disks.
Space is the least important factor. Even 1T will be enough.
Which RAID level would you recommend in this situation. The current options are 60, 50 and 10, but probably other options can be even better.
Thank you!