From: Scott Carey <scott@richrelevance.com>
To: Scott Carey <scott@richrelevance.com>
Cc: Digimer <linux@alteeve.com>
Cc: Eric Comeau <ecomeau@signiant.com>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: How to achieve sustained disk performance of 1.25 GB write for 5 mins
Date: Wed, 17 Nov 2010 10:58:36 -0800
Message-ID: <509EE238-275F-4FA0-BACD-24F77DA2F7C0@richrelevance.com> (raw)
In-Reply-To: <2CE778F3-1147-4AC3-AA33-1911EDDD7AB9@richrelevance.com>
References: <ic0onf$3fi$1@news.hub.org>
<4CE3F498.3060004@alteeve.com>
<2CE778F3-1147-4AC3-AA33-1911EDDD7AB9@richrelevance.com>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: scott@richrelevance.com, linux@alteeve.com, ecomeau@signiant.com
Subject: Re: How to achieve sustained disk performance of 1.25 GB write for 5 mins
In-Reply-To: <509EE238-275F-4FA0-BACD-24F77DA2F7C0@richrelevance.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox