| From: | Scott Carey <scott(at)richrelevance(dot)com> |
|---|---|
| To: | Scott Carey <scott(at)richrelevance(dot)com> |
| Cc: | Digimer <linux(at)alteeve(dot)com>, Eric Comeau <ecomeau(at)signiant(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: How to achieve sustained disk performance of 1.25 GB write for 5 mins |
| Date: | 2010-11-17 18:58:36 |
| Message-ID: | 509EE238-275F-4FA0-BACD-24F77DA2F7C0@richrelevance.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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). Just 2 PCIe slots. The cost seems to be not too bad, at least for "how much does it cost to go 600MB/sec". $1200 will get two of them, for a total of 480GB and 1300MB/sec.
Note, these are not data-safe on power failure.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Carey | 2010-11-17 19:26:30 | Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1? |
| Previous Message | Scott Carey | 2010-11-17 18:48:04 | Re: How to achieve sustained disk performance of 1.25 GB write for 5 mins |