Re: Recommendations for SSDs in production?

From: Thomas Mieslinger <miesi(at)pc-h(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Recommendations for SSDs in production?
Date: 2011-11-04 09:28:38
Message-ID: 4EB3B046.8000406@pc-h.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Am 03.11.2011 18:59, schrieb Robert Treat:
> On Wed, Nov 2, 2011 at 11:02 PM, Benjamin Smith
> <lists(at)benjamindsmith(dot)com> wrote:
>> On Wednesday, November 02, 2011 11:39:25 AM Thomas Strunz wrote:
>>> I guess go Intel
>>> route or some other crazy expensive enterprise stuff.
>>
>> It's advice about some of the "crazy expensive enterprise" stuff that I'm
>> seeking...? I don't mind spending some money if I get to keep up this level of

Stec (http://stec-inc.com/) or texas memory systems
(http://www.ramsan.com/) do the kind of ssds you want for enterprise
application. Reading the specs for intel 320, 710 you can calculate how
long ssds will live when loaded with maximum random io workload.

intel 320 80GB 10TB written 10000 4k IOPS
about 3 days to the of end design lifetime

intel 710 100GB 500TB written 2700 4k IOPS
about 575 days to the of end design lifetime

If you are using Linux you can use the values in /proc/iostats to get a
rough idea what your system is doing and how many tb get written per day.

stec offers a wear resistant ssd which is composed from 8GB RAM, a big
capacitor, 8GB Flash and some logic to write the ram contents into flash
when the power has gone.

see
http://www.intel.com/content/dam/doc/product-brief/ssd-320-brief.pdf

http://www.intel.com/content/dam/doc/product-specification/ssd-710-series-specification.pdf

http://embeddedcomputingsystems.com/wp-content/uploads/2011/05/STEC_AVNET_SSD_Spring2011.pdf

>> performance, but also am not looking to make somebody's private plane payment,
>> either.
>
> There's a pretty varied mix of speed, durability, and price with any
> SSD based architecture, but the two that have proven best in our
> testing and production use (for ourselves and our clients) seem to be
> Intel (mostly 320 series iirc), and Fusion-IO. I'd start with looking
> at those.
>
> Robert Treat
> conjecture: xzilla.net
> consulting: omniti.com
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Naoko Reeves 2011-11-04 12:05:15 Re: ERROR from pg_restore - From OS X to Ubuntu
Previous Message Albe Laurenz 2011-11-04 09:06:35 Re: ERROR from pg_restore - From OS X to Ubuntu