Re: Six PostgreSQL questions from a pokerplayer

Craig Ringer wrote:
> On Sat, 2009-07-04 at 11:51 -0700, Patvs wrote:
>
>
>   
>> With 4 regular harddisks in RAID0 you get great read/write speeds, but the
>> SSDs excel in IO/s and a 0.1ms access time.
>>     
>
> ... but are often really, really, really, really slow at writing. The
> fancier ones are fast at writing but generally slow down over time.
>
>   

Also, (probably pointing out the obvious here) to be on the safe side 
you should avoid RAID0 for any data that is important to you - as it's 
pretty easy to get one bad disk straight from new!

With respect to SSD's one option for a small sized database is 2xSSD in 
RAID1 - provided they are the *right* SSD that is, which at this point 
in time seems to be the Intel X25E. Note that I have not benchmarked 
this configuration, so no guarantees that it (or the Intel SSDs 
themselves) are as good as the various on-the-web tests indicate!

regards

Mark