Re: Upgrading my BSDI box, again

From: Christopher Browne <cbbrowne(at)libertyrms(dot)info>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Upgrading my BSDI box, again
Date: 2003-07-30 21:07:31
Message-ID: 60u193soz0.fsf@dev6.int.libertyrms.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Bruce Momjian wrote:
> Andrew Sullivan wrote:
> > On Wed, Jul 30, 2003 at 12:38:54AM -0400, Bruce Momjian wrote:
> > > Guys, I just replied to this email on the BSDi email list. The issue is
> > > that someone found that some(most?) IDE drives have write cache enabled,
> > > though the drives do not preserve the write cache data on power failure.
> >
> > It's yet worse than this. Some IDE drives will respond to the
> > command to turn off write cacheing, but they _don't actually turn it
> > off_. In other words, you think you've done the right thing, and you
> > haven't anyway.

> Is there an interface to control this with IDE drives? I know there
> is scsicmd for SCSI, but I didn't think IDE had any similar
> interface to control the drive.

On Linux, there's something called "hdparm." There could be something
analogous, but that misses Andrew's point.

The point is that even if you have a utility that can modify caching
parameters, this is increasingly unlikely to do you any good, because
the hard drive may be lying to you.

The drive happily reports back "Yup! I shut the cache off for you!"

But then proceeds to cache writes anyways, because it was lying when
it said it shut it off.

What OS you're using is irrelevant if the hardware is lying to you.
--
(format nil "~S(at)~S" "cbbrowne" "libertyrms.info")
<http://dev6.int.libertyrms.com/>
Christopher Browne
(416) 646 3304 x124 (land)

Browse pgsql-hackers by date

  From Date Subject
Next Message Sean Chittenden 2003-07-30 21:10:26 Re: [PATCHES] [PATCH] Re: Why READ ONLY transactions?
Previous Message Nailah Ogeer 2003-07-30 21:03:57 File Cache