Search Postgresql Archives

Re: Recommendations for SSDs in production?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Wed, Nov 2, 2011 at 12:01 PM, Benjamin Smith
<lists@xxxxxxxxxxxxxxxxxx> 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

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux