From: Yeb Havinga <yebhavinga@gmail.com>
To: Michal Szymanski <mich20061@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: SSD, Postgres and safe write cache
Date: Mon, 25 Jun 2012 18:05:12 +0200
Message-ID: <4FE88C38.1010604@gmail.com> (raw)
In-Reply-To: <f9d6d786-867f-4d25-ad93-646d842e09fd@googlegroups.com>
References: <f9d6d786-867f-4d25-ad93-646d842e09fd@googlegroups.com>
On 2012-06-20 16:51, Michal Szymanski wrote:
> Hi,
> We started to think about using SSD drive for our telco system DB. Because we have many "almost" read-only data I think SSD is good candidate for our task. We would like to speed up process of read operation.
> I've read post (http://blog.2ndquadrant.com/intel_ssd_now_off_the_sherr_sh/) about SSD which have write safe functionality and two drive are recommended Intel 320 and Vertex2 Pro. Both drive are rather inexpensive but both using old SATA II.
> I tried to find newer faster version of Vertex because production Vertex 2 Pro is stopped but there is no information about new drives that has similar functionality and are cheap. Do you recommend cheap SSD drives that are suitable for DB needs?
We were able to get OCZ Deneva 2's
(http://www.oczenterprise.com/downloads/solutions/ocz-deneva2-r-mlc-2.5in_Product_Brief.pdf)
from our supplier, which were suggested by OCZ as replacement for the
vertex 2 pro's. They're marketed as safe under power failure and our
tests with the diskchecker tool confirmed that.
regards,
Yeb Havinga
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: yebhavinga@gmail.com, mich20061@gmail.com
Subject: Re: SSD, Postgres and safe write cache
In-Reply-To: <4FE88C38.1010604@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox