Re: Recommendations for SSDs in production? - Mailing list pgsql-general

From Merlin Moncure
Subject Re: Recommendations for SSDs in production?
Date
Msg-id CAHyXU0xEKGZVSHNDubXZHR9PAq6y4duazoLzZ=v-F5ROJku+OQ@mail.gmail.com
Whole thread Raw
In response to Recommendations for SSDs in production?  (Benjamin Smith <lists@benjamindsmith.com>)
Responses Re: Recommendations for SSDs in production?  (Thomas Strunz <beginner_@hotmail.de>)
List pgsql-general
On Wed, Nov 2, 2011 at 12:01 PM, Benjamin Smith
<lists@benjamindsmith.com> wrote:
> Well,
>
> After reading several glowing reviews of the new OCZ Vertex3 SSD last spring,
> we did some performance testing in dev on RHEL6. (CentOS)
>
> The results were nothing short of staggering. Complex query results returned
> in 1/10th the time as a pessimistic measurement. System loads dropped from 2+
> to 0.1 or less.
>
> Wow.
>
> So after months of using this SSD without any issues at all, we tentatively
> rolled this out to production, and had blissful, sweet beauty until about 2
> weeks ago, now we are running into sudden death scenarios. We have excellent
> backup system, so the damage is reduced to roadbumps, but are looking for a
> longer term solution that doesn't compromise performance too much.
>
> The config is super-basic, basically no tuning at all was done:
>
> # fdisk /dev/NNN;
> mke2fs -j $partn;
> mount $partn /var/lib/pgsql;
> rsync -vaz /var/lib/pgsql.old /var/lib/pgsql;
> service postgresql start;
>
> I don't mind spending some money. Can anybody comment on a recommended drive
> in real world use?
>
> After some review I found:
>
> 1) Micron P300 SSD: claims excellent numbers, can't find them for sale
> anywhere.
>
> 2) Intel X25E - good reputation, significantly slower than the Vertex3. We're
> buying some to reduce downtime.
>
> 3) OCZ "Enterprise" - reviews are mixed.
>
> 4) Kingston "Enterprise" drives appear to be identical to consumer drives with
> a different box.
>
> 5) STEC drives are astronomically expensive. (EG: "You're kidding, right?")
>
> 6) Corsair consumer drives getting excellent reviews, Aberdeen Inc recommended
> in use with RAID 1.
>
> 7) Seagate Pulsar drives, XT.2 drives are expensive SLC but can't find a
> vendor, Pulsar .2 drives are more available but having trouble finding reviews
> other than rehashed press releases.
>
> Thanks!

The X25-E is now essentially being replaced by the 710.  I would look there.

merlin

pgsql-general by date:

Previous
From: Benjamin Smith
Date:
Subject: Recommendations for SSDs in production?
Next
From: Robert Treat
Date:
Subject: Re: Why is there no 8.3.16 rpm with _id ?