Re: Hardware vs Software RAID

From: Matthew Wakeling <matthew(at)flymine(dot)org>
To: Vivek Khera <vivek(at)khera(dot)org>
Cc: Pgsql performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Hardware vs Software RAID
Date: 2008-06-26 16:14:06
Message-ID: Pine.LNX.4.64.0806261705280.4085@aragorn.flymine.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Scott Marlowe 2008-06-26 16:31:52 Re: Hardware vs Software RAID
Previous Message Scott Marlowe 2008-06-26 16:02:31 Re: [PERFORM] 答复: [PERFORM] Postgresql update op is very very slow