pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Ang Chin Han <angch@bytecraft.com.my>
To: Andrew Sullivan <andrew@libertyrms.info>
Cc: pgsql-performance@postgresql.org
Subject: Re: inferior SCSI performance
Date: Thu, 02 Oct 2003 16:54:09 +0800
Message-ID: <3F7BE7B1.5090005@bytecraft.com.my> (raw)
In-Reply-To: <20031001103338.GA29293@libertyrms.info>
References: <3F688CC5.12621.4EBFDCC@localhost>
	<Pine.NEB.4.58.0309171445240.1444@reva.sixgirls.org>
	<4693.1063825713@sss.pgh.pa.us>
	<Pine.NEB.4.58.0309171522170.1444@reva.sixgirls.org>
	<20031001103338.GA29293@libertyrms.info>

Andrew Sullivan wrote:

> Yes.  If and only if you have a battery-backed cache.  I know of no
> IDE drives that have that, but there's nothing about the spec which
> makes it impossible.

http://www.ussg.iu.edu/hypermail/linux/kernel/0103.0/1084.html

Relevant section:
<quote>
Maybe that is why there is a vender disk-cache dump zone on the edge of
the platters...just maybe you need to buy your drives from somebody that
does this and has a predictive sector stretcher as the energy from the
inertia by the DC three-phase motor executes the dump.

Ever wondered why modern drives have open collectors on the databuss?
Maybe to disconnect the power draw so that the motor now generator
provides the needed power to complete the data dump...
</quote>

SEEMS to imply that some IDE drives at least have enough power left 
after power's off to store the write-cached data to disk.

The rest of the email's not very reassuring, though, but note that this 
email's two years old.

Anyone want to test? :)

-- 
Linux homer 2.4.18-14 #1 Wed Sep 4 13:35:50 EDT 2002 i686 i686 i386 
GNU/Linux
   4:30pm  up 280 days,  8:00,  8 users,  load average: 6.05, 6.01, 6.02

view thread (11+ messages)  latest in thread

Message-ID: <3F7BE7B1.5090005@bytecraft.com.my>
Permalink:  ../3F7BE7B1.5090005@bytecraft.com.my/
Also on:    postgresql.org/message-id/3F7BE7B1.5090005@bytecraft.com.my

 · 

reply

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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-performance@postgresql.org
  Cc: angch@bytecraft.com.my, andrew@libertyrms.info
  Subject: Re: inferior SCSI performance
  In-Reply-To: <3F7BE7B1.5090005@bytecraft.com.my>
  References: <3F688CC5.12621.4EBFDCC@localhost> <Pine.NEB.4.58.0309171445240.1444@reva.sixgirls.org> <4693.1063825713@sss.pgh.pa.us> <Pine.NEB.4.58.0309171522170.1444@reva.sixgirls.org> <20031001103338.GA29293@libertyrms.info> <3F7BE7B1.5090005@bytecraft.com.my>

* 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