Re: [PERFORM] choosing the right RAID level for PostgresQL database

2011-02-14 Thread david
On Sun, 13 Feb 2011, Dave Crooke wrote: 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. there are two situations where you would opt for something other than RAID-10 1. if you need the space that raid

Re: [PERFORM] choosing the right RAID level for PostgresQL database

2011-02-13 Thread Dave Crooke
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 wrote: > Hello, > > I got a disk array appliance of 8 disks 1T each (UltraStor RS8IP4). It will > be used

Re: [PERFORM] choosing the right RAID level for PostgresQL database

2011-02-13 Thread Greg Smith
sergey wrote: 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. .. Space is the least important factor. Even 1T will be enough. Use RAID10, measure the speed of the whole arra

Re: [PERFORM] choosing the right RAID level for PostgresQL database

2011-02-13 Thread Scott Marlowe
On Sun, Feb 13, 2011 at 3:54 PM, Scott Marlowe wrote: > On Sun, Feb 13, 2011 at 1:12 PM, sergey 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. >> >

Re: [PERFORM] choosing the right RAID level for PostgresQL database

2011-02-13 Thread Scott Marlowe
On Sun, Feb 13, 2011 at 1:12 PM, sergey 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 lar

[PERFORM] choosing the right RAID level for PostgresQL database

2011-02-13 Thread sergey
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/sc