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 Marlowe||Date: 2008-06-26 16:31:52|
|Subject: Re: Hardware vs Software RAID|
|Previous:||From: Scott Marlowe||Date: 2008-06-26 16:02:31|
|Subject: Re: [PERFORM] 答复: [PERFORM] Postgresql update op is very very slow|