X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 780A4D1B52A for ; Thu, 2 Oct 2003 08:52:41 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 46914-06 for ; Thu, 2 Oct 2003 05:51:56 -0300 (ADT) Received: from cerebro.int-bytecraft.com (unknown [219.93.229.26]) by svr1.postgresql.org (Postfix) with ESMTP id D7D61D1B554 for ; Thu, 2 Oct 2003 05:51:52 -0300 (ADT) Received: from bytecraft.com.my (home.int-bytecraft.com [127.0.0.1]) by cerebro.int-bytecraft.com (8.11.6/8.11.6) with ESMTP id h928oRM10865; Thu, 2 Oct 2003 16:50:28 +0800 Message-ID: <3F7BE7B1.5090005@bytecraft.com.my> Date: Thu, 02 Oct 2003 16:54:09 +0800 From: Ang Chin Han User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.4) Gecko/20030624 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Andrew Sullivan Cc: pgsql-performance@postgresql.org Subject: Re: inferior SCSI performance References: <3F688CC5.12621.4EBFDCC@localhost> <4693.1063825713@sss.pgh.pa.us> <20031001103338.GA29293@libertyrms.info> In-Reply-To: <20031001103338.GA29293@libertyrms.info> X-Enigmail-Version: 0.76.5.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="------------enig78C486BCA5B58DFCB52BC8A0" X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/44 X-Sequence-Number: 3792 This is an OpenPGP/MIME signed message (RFC 2440 and 3156) --------------enig78C486BCA5B58DFCB52BC8A0 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit 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: 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... 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 --------------enig78C486BCA5B58DFCB52BC8A0 Content-Type: application/pgp-signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE/e+e1NYbTUIgzwfARAjjcAJ42ODNKuUZhif7LbuE6UXb4PGZAIwCg1UvR YXV2n7yeU5E4EjfWHKoF3Nk= =kdzz -----END PGP SIGNATURE----- --------------enig78C486BCA5B58DFCB52BC8A0--