From: Greg Smith <gsmith@gregsmith.com>
To: James Mansion <james@mansionfamily.plus.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: POSIX file updates
Date: Wed, 2 Apr 2008 19:49:58 -0400 (EDT)
Message-ID: <Pine.GSO.4.64.0804021940070.7947@westnet.com> (raw)
In-Reply-To: <47F40D54.2020700@mansionfamily.plus.com>
References: <47F1413B.40109@mansionfamily.plus.com>
<Pine.GSO.4.64.0803311618040.15117@westnet.com>
<47F3DA25.7050705@mansionfamily.plus.com>
<1207167852.8299.179.camel@localhost>
<47F40D54.2020700@mansionfamily.plus.com>
On Wed, 2 Apr 2008, James Mansion wrote:
> I'm well aware that there are battery-backed caches that can be detached
> from controllers and moved. But you'd better make darn sure you move
> all the drives and plug them in in exactly the right order and make sure
> they all spin up OK with the replaced cache, because its expecting them
> to be exactly as they were last time they were on the bus.
The better controllers tag the drives with a unique ID number so they can
route pending writes correctly even after such a disaster. This falls
into the category of tests people should do more often but don't: write
something into the cache, pull the power, rearrange the drives, and see if
everything still recovers.
> You would think hard drives could have enough capacitor store to dump
> cache to flash or the drive - if only to a special dump zone near where
> the heads park. They are spinning already after all.
The free market seems to have established that the preferred design model
for hard drives is that they be cheap and fast rather than focused on
reliability. I rather doubt the tiny percentage of the world who cares as
much about disk write integrity as database professionals do can possibly
make a big enough market to bother increasing the cost and design
complexity of the drive to do this.
--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD
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: gsmith@gregsmith.com, james@mansionfamily.plus.com
Subject: Re: POSIX file updates
In-Reply-To: <Pine.GSO.4.64.0804021940070.7947@westnet.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