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

From Vivek Khera
Subject Re: Hardware vs Software RAID
Date
Msg-id 97454AF8-315A-4B3D-8F95-D96B190C6909@khera.org
Whole thread Raw
In response to Re: Hardware vs Software RAID  (Matthew Wakeling <matthew@flymine.org>)
Responses Re: Hardware vs Software RAID
List pgsql-performance
On Jun 25, 2008, at 11:35 AM, Matthew Wakeling wrote:

> On Wed, 25 Jun 2008, Greg Smith wrote:
>> A firewire-attached log device is an extremely bad idea.
>
> 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.

pgsql-performance by date:

Previous
From: Greg Smith
Date:
Subject: Re: Hardware vs Software RAID
Next
From: Andrew Sullivan
Date:
Subject: Re: ??: Postgresql update op is very very slow