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>
To: Scott Carey <scott@richrelevance.com>
Cc: jd@commandprompt.com
Cc: pgsql-performance@postgresql.org
Subject: Re: Create and drop temp table in 8.3.4
Date: Thu, 06 Nov 2008 16:33:43 -0600
Message-ID: <49131C67.EE98.0025.0@wicourts.gov> (raw)
In-Reply-To: <dcc563d10811061405l76cb59adh58741b227fe9d8a6@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>

>>> "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?
 
It does seem fairly bizarre to me that we can't configure our system
to enforce write barriers within the OS and file system without having
it enforced all the way past the BBU RAID cache onto the hard drives
themselves.  We consider that once it hits the battery-backed cache,
it is persisted.  Reality has only contradicted that once so far (with
a RAID controller failure), and our backups have gotten us past that
with no sweat.
 
-Kevin



view thread (17+ messages)  latest in thread

Message-ID: <49131C67.EE98.0025.0@wicourts.gov>
Permalink:  ../49131C67.EE98.0025.0@wicourts.gov/
Also on:    postgresql.org/message-id/49131C67.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, scott@richrelevance.com, jd@commandprompt.com
  Subject: Re: Create and drop temp table in 8.3.4
  In-Reply-To: <49131C67.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