Re: Deploying PostgreSQL on CentOS with SSD and Hardware RAID - Mailing list pgsql-general

From Merlin Moncure
Subject Re: Deploying PostgreSQL on CentOS with SSD and Hardware RAID
Date
Msg-id CAHyXU0yXCSeKY7HZgF3xs3sTk0d8CbqXbM31554j+3Y-R9eLtw@mail.gmail.com
Whole thread Raw
In response to Re: Deploying PostgreSQL on CentOS with SSD and Hardware RAID  (David Boreham <david_list@boreham.org>)
Responses Re: Deploying PostgreSQL on CentOS with SSD and Hardware RAID  (Lonni J Friedman <netllama@gmail.com>)
Re: Deploying PostgreSQL on CentOS with SSD and Hardware RAID  (David Boreham <david_list@boreham.org>)
List pgsql-general
On Fri, May 10, 2013 at 12:03 PM, David Boreham <david_list@boreham.org> wrote:
> On 5/10/2013 10:21 AM, Merlin Moncure wrote:
>>
>> As it turns out the list of flash drives are suitable for database use is
>> surprisingly small. The s3700 I noted upthread seems to be specifically
>> built with databases in mind and is likely the best choice for new
>> deployments. The older Intel 320 is also a good choice. I think that's
>> pretty much it until you get into expensive pci-e based gear.
>
>
> This may have been a typo : did you mean Intel 710 series rather than 320 ?
>
> While the 320 has the supercap, it isn't specified for high write endurance.
> Definitely usable for a database, and a better choice than most of the
> alternatives, but I'd have listed the 710 ahead of the 320.

It wasn't a typo.  The 320 though is perfectly fine although it will
wear out faster -- so it fills a niche for low write intensity
applications.  I find the s3700 to be superior to the 710 in just
about every way (although you're right -- it is suitable for database
use).

merlin


pgsql-general by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: pg_basebackup, requested WAL has already been removed
Next
From: Steve Clark
Date:
Subject: Re: Deploying PostgreSQL on CentOS with SSD and Hardware RAID