From: Greg Smith <greg@2ndQuadrant.com>
To: Merlin Moncure <mmoncure@gmail.com>
Cc: Joshua D. Drake <jd@commandprompt.com>
Cc: sthomas@optionshouse.com, Tomas Vondra <tv@fuzzy.cz>
Cc: pgsql-performance@postgresql.org
Subject: Re: Reliability with RAID 10 SSD and Streaming Replication
Date: Wed, 22 May 2013 16:06:58 -0400
Message-ID: <519D2562.2060604@2ndQuadrant.com> (raw)
In-Reply-To: <CAHyXU0wUHDiGVWgejxsFNApiP0sUcf8eLOy1Dwy-1pboBuxLeQ@mail.gmail.com>
References: <CAAE-9WHMycEZOB5J6HKME5AZLEdL2hYF+FV8hzbLksJinq=EJg@mail.gmail.com>
<51957499.6050905@fuzzy.cz>
<519991EB.8010208@2ndQuadrant.com>
<519A8E29.60702@fuzzy.cz>
<CAHyXU0wvW-USgbkXAYEHLG2fHgj=UdZi1aCFoVWBMQEsOFZy+A@mail.gmail.com>
<519C0EFD.9080002@2ndQuadrant.com>
<CAHyXU0ymFT7Sqw77yPryGWKEpjV4Wv9Vkc21vGtPKo0GZWGg8A@mail.gmail.com>
<519CF8CC.1030204@optionshouse.com>
<519D0921.9080807@2ndQuadrant.com>
<519D174A.4050703@commandprompt.com>
<519D1CD6.2080607@2ndQuadrant.com>
<CAHyXU0wUHDiGVWgejxsFNApiP0sUcf8eLOy1Dwy-1pboBuxLeQ@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
On 5/22/13 3:51 PM, Merlin Moncure wrote:
> s3700 is rated for 10 drive writes/day for 5 years. so, for 200gb drive, that's
> 200gb * 10/day * 365 days * 5, that's 3.65 million gigabytes or ~ 3.5 petabytes.
Yes, they've improved on the 1.5PB that the 710 drives topped out at.
For that particular drive, this is unlikely to be a problem. But I'm
not willing to toss out longevity issues at therefore irrelevant in all
cases. Some flash still costs a lot more than Intel's SSDs do, like the
FusionIO products. Chop even a few percent of the wear out of the price
tag on a RAMSAN and you've saved some real money.
And there are some other products with interesting
price/performance/capacity combinations that are also sensitive to
wearout. Seagate's hybrid drives have turned interesting now that they
cache writes safely for example. There's no cheaper way to get 1TB with
flash write speeds for small commits than that drive right now. (Test
results on that drive coming soon, along with my full DC S3700 review)
> btw, cost/pb of this drive is less than half of
> the 710 (which IMO was obsolete the day the s3700 hit the street).
You bet, and I haven't recommended anyone buy a 710 since the
announcement. However, "hit the street" is still an issue. No one has
been able to keep DC S3700 drives in stock very well yet. It took me
three tries through Newegg before my S3700 drive actually shipped.
--
Greg Smith 2ndQuadrant US greg@2ndQuadrant.com Baltimore, MD
PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.com
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
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: greg@2ndQuadrant.com, mmoncure@gmail.com, jd@commandprompt.com, tv@fuzzy.cz
Subject: Re: Reliability with RAID 10 SSD and Streaming Replication
In-Reply-To: <519D2562.2060604@2ndQuadrant.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