Received: from localhost (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 823136503FB
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Thu,  6 Nov 2008 19:04:08 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 65309-03
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Thu,  6 Nov 2008 19:04:07 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from gwmta.wicourts.gov (gwmta.wicourts.gov [165.219.244.99])
	by mail.postgresql.org (Postfix) with ESMTP id A94876502BE
	for <pgsql-performance@postgresql.org>;
	Thu,  6 Nov 2008 19:04:06 -0400 (AST)
Received: from Courts-MTA by gwmta.wicourts.gov
	with Novell_GroupWise; Thu, 06 Nov 2008 17:04:05 -0600
Message-Id: <49132383.EE98.0025.0@wicourts.gov>
X-Mailer: Novell GroupWise Internet Agent 7.0.3 
Date: Thu, 06 Nov 2008 17:04:03 -0600
From: "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
To: "Scott Marlowe" <scott.marlowe@gmail.com>
Cc: <jd@commandprompt.com>,<pgsql-performance@postgresql.org>,
	"Scott Carey" <scott@richrelevance.com>
Subject: Re: Create and drop temp table in 8.3.4
References: <4911957A.EE98.0025.0@wicourts.gov>
	<4911D4DB.EE98.0025.0@wicourts.gov> <4912EAFF.EE98.0025.0@wicourts.gov>
	<1225999071.1204.14.camel@jd-laptop.pragmaticzealot.org>
	<4912F29E.EE98.0025.0@wicourts.gov>
	<a1ec7d000811061305n7b28800od469c1411e1a9928@mail.gmail.com>
	<dcc563d10811061405l76cb59adh58741b227fe9d8a6@mail.gmail.com>
	<49131C67.EE98.0025.0@wicourts.gov>
	<dcc563d10811061445h32c5ad72o84f367d7cc3c6899@mail.gmail.com>
In-Reply-To: <dcc563d10811061445h32c5ad72o84f367d7cc3c6899@mail.gmail.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
X-Archive-Number: 200811/44
X-Sequence-Number: 31775

>>> "Scott Marlowe" <scott.marlowe@gmail.com> wrote: 
> On Thu, Nov 6, 2008 at 3:33 PM, Kevin Grittner
> <Kevin.Grittner@wicourts.gov> wrote:
>>>>> "Scott Marlowe" <scott.marlowe@gmail.com> wrote:
>>> I am pretty sure that with no write barriers that even a BBU
>> hardware
>>> caching raid controller cannot guarantee your data.
>>
>> That seems at odds with this:
>>
>> http://oss.sgi.com/projects/xfs/faq.html#wcache_persistent
>>
>> What evidence to you have that the SGI XFS team is wrong?
> 
> Without write barriers in my file system an fsync request will
> be immediately returned true, correct?
 
Not as I understand it; although it will be pretty fast if it all fits
into the battery backed cache.
 
-Kevin