Re: How to achieve sustained disk performance of 1.25 GB write for 5 mins - Mailing list pgsql-performance

From Scott Carey
Subject Re: How to achieve sustained disk performance of 1.25 GB write for 5 mins
Date
Msg-id 509EE238-275F-4FA0-BACD-24F77DA2F7C0@richrelevance.com
Whole thread Raw
In response to Re: How to achieve sustained disk performance of 1.25 GB write for 5 mins  (Scott Carey <scott@richrelevance.com>)
List pgsql-performance
On Nov 17, 2010, at 10:48 AM, Scott Carey wrote:

>>
>> Off hand, I would suggest:
>>
>> 8x http://www.kingston.com/ssd/vplus100.asp (180MB/sec sustained write)
>> stripped (RAID 0, you did say that you don't care about safety). That
>> should be 1.44GB/sec write, minus overhead.
>
> Can get cheaper disks that go ~135MB/sec write and a couple more of them.
>

Another option, two of these (650MB+ /sec sustained) in raid 0:
http://www.anandtech.com/show/3997/ocz-revodrive-x2-review/3

No external enclosure required, no raid card required (the card is basically 4 ssd's raided together in one package).
Just2 PCIe slots.  The cost seems to be not too bad, at least for "how much does it cost to go 600MB/sec".   $1200 will
gettwo of them, for a total of 480GB and 1300MB/sec. 

Note, these are not data-safe on power failure.



pgsql-performance by date:

Previous
From: Scott Carey
Date:
Subject: Re: How to achieve sustained disk performance of 1.25 GB write for 5 mins
Next
From: Scott Carey
Date:
Subject: Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?