X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id E6FD9D1CACD for ; Wed, 11 Feb 2004 06:14:26 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 57238-10 for ; Wed, 11 Feb 2004 02:14:10 -0400 (AST) Received: from secure.icanx.com (secure.icanx.com [64.246.58.55]) by svr1.postgresql.org (Postfix) with ESMTP id 4CA2FD1CA90 for ; Wed, 11 Feb 2004 02:14:09 -0400 (AST) Received: from 63-229-201-197.mpls.qwest.net ([63.229.201.197] helo=[192.168.2.102]) by secure.icanx.com with esmtp (Exim 4.24) id 1AqndP-0007Jz-RK for pgsql-admin@postgresql.org; Wed, 11 Feb 2004 01:14:07 -0500 Mime-Version: 1.0 (Apple Message framework v612) Content-Transfer-Encoding: 7bit Message-Id: <7FADF594-5C59-11D8-9292-000A9579AF50@indeq.com> Content-Type: text/plain; charset=US-ASCII; format=flowed To: pgsql-admin@postgresql.org From: Mark Lubratt Subject: IDE and write cache Date: Wed, 11 Feb 2004 00:14:07 -0600 X-Mailer: Apple Mail (2.612) X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - secure.icanx.com X-AntiAbuse: Original Domain - postgresql.org X-AntiAbuse: Originator/Caller UID/GID - [0 0] / [47 12] X-AntiAbuse: Sender Address Domain - indeq.com X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/153 X-Sequence-Number: 12327 Interesting discussions on IDE drives and their write caches. I have a question... You mentioned that you'd see the problem during a large number of concurrent transactions. My question is, is this a necessary condition for the database crashing when the plug was pulled, or did you need use a large number of concurrent transactions to "guarantee" that when you pulled the plug, that it would be at an inopportune time? In other words, is an IDE drive still "more" susceptible to a power outage problem even under light load? Thanks! Mark