Re: Reliability with RAID 10 SSD and Streaming Replication

From: Merlin Moncure <mmoncure(at)gmail(dot)com>
To: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
Cc: Greg Smith <greg(at)2ndquadrant(dot)com>, sthomas(at)optionshouse(dot)com, Tomas Vondra <tv(at)fuzzy(dot)cz>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Reliability with RAID 10 SSD and Streaming Replication
Date: 2013-05-22 23:37:39
Message-ID: CAHyXU0ypax17SNweZfcy-84KX1cyHAF=AP7NepBSz8n8RrzihQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Wed, May 22, 2013 at 5:42 PM, Joshua D. Drake <jd(at)commandprompt(dot)com> wrote:
> I am curious how the 710 or S3700 stacks up against the new M500 from
> Crucial? I know Intel is kind of the goto for these things but the m500 is
> power off protected and rated at: Endurance: 72TB total bytes written (TBW),
> equal to 40GB per day for 5 years .

I don't think the m500 is power safe (nor is any drive at the <1$/gb
price point). This drive is positioned as a desktop class disk drive.
AFAIK, the s3700 strongly outclasses all competitors on price,
performance, or both. Once you give up enterprise features of
endurance and iops you have many options (samsung 840 is another one).
Pretty soon these types of drives are going to be standard kit in
workstations (and we'll be back to the IDE area of corrupted data,
ha!). I would recommend none of them for server class use, they are
inferior in terms of $/iop and $/gb written.

for server class drives, see:
hitachi ssd400m (10$/gb, slower!)
kingston e100,
etc.

merlin

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Jeff Janes 2013-05-23 00:17:26 Re: Very slow inner join query Unacceptable latency.
Previous Message Joshua D. Drake 2013-05-22 22:42:36 Re: Reliability with RAID 10 SSD and Streaming Replication