Received: from localhost (maia-2.hub.org [200.46.204.187])
	by postgresql.org (Postfix) with ESMTP id B69189FB35A
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Wed, 28 Feb 2007 23:35:37 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024)
	with ESMTP id 23336-08 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Wed, 28 Feb 2007 23:35:11 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.4
Received: from wolff.to (wolff.to [66.93.197.194])
	by postgresql.org (Postfix) with SMTP id 611CF9FB422
	for <pgsql-performance@postgresql.org>;
	Wed, 28 Feb 2007 23:35:23 -0400 (AST)
Received: (qmail 16375 invoked by uid 500); 1 Mar 2007 03:35:21 -0000
Date: Wed, 28 Feb 2007 21:35:21 -0600
From: Bruno Wolff III <bruno@wolff.to>
To: Shane Ambler <pgsql@Sheeky.Biz>
Cc: Peter Kovacs <maxottovonstirlitz@gmail.com>,
	Jeff Davis <pgsql@j-davis.com>, Tom Lane <tgl@sss.pgh.pa.us>,
	Carlos Moreno <moreno_pg@mochima.com>, pgsql-performance@postgresql.org
Subject: Re: Two hard drives --- what to do with them?
Message-ID: <20070301033521.GC14102@wolff.to>
Mail-Followup-To: Bruno Wolff III <bruno@wolff.to>,
	Shane Ambler <pgsql@Sheeky.Biz>,
	Peter Kovacs <maxottovonstirlitz@gmail.com>,
	Jeff Davis <pgsql@j-davis.com>, Tom Lane <tgl@sss.pgh.pa.us>,
	Carlos Moreno <moreno_pg@mochima.com>,
	pgsql-performance@postgresql.org
References: <45E0A500.1010707@commandprompt.com>
	<45E104DD.3080600@mochima.com> <2055.1172375931@sss.pgh.pa.us>
	<b6e8f2e80702251411q5a27eb53re9c2a299b8e3880a@mail.gmail.com>
	<1172526666.10824.315.camel@dogma.v10.wvs>
	<b6e8f2e80702261611j598b1771g3dbcfc9bb1f9cdf2@mail.gmail.com>
	<1172535914.10824.327.camel@dogma.v10.wvs>
	<45E3BC09.60100@Sheeky.Biz>
	<b6e8f2e80702270027s1c684f42vb3eca0a1d87ed5fb@mail.gmail.com>
	<45E47DBD.6090803@Sheeky.Biz>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <45E47DBD.6090803@Sheeky.Biz>
User-Agent: Mutt/1.4.2.1i
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=1.119 tagged_above=0 required=5 tests=AWL, BAYES_50,
	BIZ_TLD
X-Spam-Level: *
X-Archive-Number: 200702/351
X-Sequence-Number: 23405

On Wed, Feb 28, 2007 at 05:21:41 +1030,
  Shane Ambler <pgsql@Sheeky.Biz> wrote:
> 
> The difference between SCSI and IDE/SATA in this case is a lot if not 
> all IDE/SATA drives tell you that the cache is disabled when you ask it 
> to but they either don't actually disable it or they don't retain the 
> setting so you get caught later. SCSI disks can be trusted when you set 
> this option.

I have some Western Digital Caviars and they don't lie about disabling
write caching.