Re: Create and drop temp table in 8.3.4 - Mailing list pgsql-performance

From Kevin Grittner
Subject Re: Create and drop temp table in 8.3.4
Date
Msg-id 49132383.EE98.0025.0@wicourts.gov
Whole thread Raw
In response to Re: Create and drop temp table in 8.3.4  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Responses Re: Create and drop temp table in 8.3.4
List pgsql-performance
>>> "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

pgsql-performance by date:

Previous
From: Peter Schuller
Date:
Subject: Re: lru_multiplier and backend page write-outs
Next
From: "Scott Marlowe"
Date:
Subject: Re: Create and drop temp table in 8.3.4