Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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?


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


pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group