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

From Benjamin Smith
Subject Recommendations for SSDs in production?
Date
Msg-id 201111021001.49488.lists@benjamindsmith.com
Whole thread Raw
Responses Re: Recommendations for SSDs in production?  (Merlin Moncure <mmoncure@gmail.com>)
Re: Recommendations for SSDs in production?  (David Boreham <david_list@boreham.org>)
Re: Recommendations for SSDs in production?  (John R Pierce <pierce@hogranch.com>)
Re: Recommendations for SSDs in production?  (Yeb Havinga <yebhavinga@gmail.com>)
Re: Recommendations for SSDs in production?  (Vick Khera <vivek@khera.org>)
List pgsql-general
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!

--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.


pgsql-general by date:

Previous
From: David Kerr
Date:
Subject: OOM Killer / PG9 / RHEL 6.1
Next
From: Merlin Moncure
Date:
Subject: Re: Recommendations for SSDs in production?