From: Greg Smith <greg@2ndQuadrant.com>
To: pgsql-performance@postgresql.org
Subject: Re: Intel SSDs that may not suck
Date: Wed, 06 Apr 2011 21:32:27 -0400
Message-ID: <4D9D142B.3030809@2ndQuadrant.com> (raw)
In-Reply-To: <C9C25160.2EB61%scott@richrelevance.com>
References: <C9C25160.2EB61%scott@richrelevance.com>
On 04/06/2011 08:22 PM, Scott Carey wrote:
> Simple power failure tests demonstrate that you lose data with these
> drives unless you disable the cache. Disabling the cache roughly drops
> write performance by a factor of 3 to 4 on G1 drives and significantly
> hurts wear-leveling and longevity (I haven't tried G2's).
>
Yup. I have a customer running a busy system with Intel X25-Es, and
another with X25-Ms, and every time there is a power failure at either
place their database gets corrupted. That those drives are worthless
for a reliable database setup has been clear for two years now:
http://www.mysqlperformanceblog.com/2009/03/02/ssd-xfs-lvm-fsync-write-cache-barrier-and-lost-transa...
and sometimes I even hear reports about those drives getting corrupted
even when the write cache is turned off. If you aggressively replicate
the data to another location on a different power grid, you can survive
with Intel's older drives. But odds are you're going to lose at least
some transactions no matter what you do, and the risk of "database won't
start" levels of corruption is always lingering.
The fact that Intel is making so much noise over the improved write
integrity features on the new drives gives you an idea how much these
problems have hurt their reputation in the enterprise storage space.
--
Greg Smith 2ndQuadrant US greg@2ndQuadrant.com Baltimore, MD
PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us
"PostgreSQL 9.0 High Performance": http://www.2ndQuadrant.com/books
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: greg@2ndQuadrant.com
Subject: Re: Intel SSDs that may not suck
In-Reply-To: <4D9D142B.3030809@2ndQuadrant.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