X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 3DC4D9FA2FA; Wed, 10 May 2006 11:44:00 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 09512-01-5; Wed, 10 May 2006 11:43:43 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- X-Greylist: from auto-whitelisted by SQLgrey- Received: from exchange.g2switchworks.com (mail.g2switchworks.com [63.87.162.25]) by postgresql.org (Postfix) with ESMTP id F0C619FA1B0; Wed, 10 May 2006 11:43:01 -0300 (ADT) Received: from 10.10.1.37 ([10.10.1.37]) by exchange.g2switchworks.com ([10.10.1.2]) with Microsoft Exchange Server HTTP-DAV ; Wed, 10 May 2006 14:42:59 +0000 Received: from state.g2switchworks.com by mail.g2switchworks.com; 10 May 2006 09:42:59 -0500 Subject: Re: [PERFORM] Arguments Pro/Contra Software Raid From: Scott Marlowe To: Bruce Momjian Cc: Steve Atkins , PostgreSQL General , "Pgsql-Performance ((E-mail))" In-Reply-To: <200605100102.k4A12wa12853@candle.pha.pa.us> References: <200605100102.k4A12wa12853@candle.pha.pa.us> Content-Type: text/plain Content-Transfer-Encoding: 7bit Message-Id: <1147272179.9755.18.camel@state.g2switchworks.com> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Wed, 10 May 2006 09:42:59 -0500 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/433 X-Sequence-Number: 95225 On Tue, 2006-05-09 at 20:02, Bruce Momjian wrote: > Scott Marlowe wrote: > > Actually, in the case of the Escalades at least, the answer is yes. > > Last year (maybe a bit more) someone was testing an IDE escalade > > controller with drives that were known to lie, and it passed the power > > plug pull test repeatedly. Apparently, the escalades tell the drives to > > turn off their cache. While most all IDEs and a fair number of SATA > > drives lie about cache fsyncing, they all seem to turn off the cache > > when you ask. > > > > And, since a hardware RAID controller with bbu cache has its own cache, > > it's not like it really needs the one on the drives anyway. > > You do if the controller thinks the data is already on the drives and > removes it from its cache. Bruce, re-read what I wrote. The escalades tell the drives to TURN OFF THEIR OWN CACHE.