Re: Hardware vs Software RAID - Mailing list pgsql-performance

From Matthew Wakeling
Subject Re: Hardware vs Software RAID
Date
Msg-id Pine.LNX.4.64.0806261705280.4085@aragorn.flymine.org
Whole thread Raw
In response to Re: Hardware vs Software RAID  (Vivek Khera <vivek@khera.org>)
Responses Re: Hardware vs Software RAID  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Re: Hardware vs Software RAID  ("Merlin Moncure" <mmoncure@gmail.com>)
List pgsql-performance
On Thu, 26 Jun 2008, Vivek Khera wrote:
>> Anyone have experience with IDE, SATA, or SAS-connected flash devices like
>> the Samsung MCBQE32G5MPP-0VA? I mean, it seems lovely - 32GB, at a transfer
>> rate of 100MB/s, and doesn't degrade much in performance when writing small
>> random blocks. But what's it actually like, and is it reliable?
>
> None of these manufacturers rates these drives for massive amounts of writes.
> They're sold as suitable for laptop/desktop use, which normally is not a
> heavy wear and tear operation like a DB.  Once they claim suitability for
> this purpose, be sure that I and a lot of others will dive into it to see how
> well it really works.  Until then, it will just be an expensive brick-making
> experiment, I'm sure.

It claims a MTBF of 2,000,000 hours, but no further reliability
information seems forthcoming. I thought the idea that flash couldn't cope
with many writes was no longer true these days?

Matthew

--
I work for an investment bank. I have dealt with code written by stock
exchanges. I have seen how the computer systems that store your money are
run. If I ever make a fortune, I will store it in gold bullion under my
bed.                                              -- Matthew Crosby

pgsql-performance by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: [PERFORM] 答复: [PERFORM] Postgresql update op is very very slow
Next
From: "Scott Marlowe"
Date:
Subject: Re: Hardware vs Software RAID