pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Kevin Grittner <Kevin.Grittner@wicourts.gov>
To: Scott Marlowe <scott.marlowe@gmail.com>
Cc: jd@commandprompt.com
Cc: pgsql-performance@postgresql.org
Cc: Scott Carey <scott@richrelevance.com>
Subject: Re: Create and drop temp table in 8.3.4
Date: Thu, 06 Nov 2008 17:04:03 -0600
Message-ID: <49132383.EE98.0025.0@wicourts.gov> (raw)
In-Reply-To: <dcc563d10811061445h32c5ad72o84f367d7cc3c6899@mail.gmail.com>
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>

>>> "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



view thread (17+ messages)  latest in thread

Message-ID: <49132383.EE98.0025.0@wicourts.gov>
Permalink:  ../49132383.EE98.0025.0@wicourts.gov/
Also on:    postgresql.org/message-id/49132383.EE98.0025.0@wicourts.gov

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: Kevin.Grittner@wicourts.gov, scott.marlowe@gmail.com, jd@commandprompt.com, scott@richrelevance.com
  Subject: Re: Create and drop temp table in 8.3.4
  In-Reply-To: <49132383.EE98.0025.0@wicourts.gov>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox