Re: Weird XFS WAL problem - Mailing list pgsql-performance

From Scott Marlowe
Subject Re: Weird XFS WAL problem
Date
Msg-id AANLkTimBauZ7cZ5Ba78-a9KsaBO418xGJHFT0vGidK8A@mail.gmail.com
Whole thread Raw
In response to Re: Weird XFS WAL problem  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Responses Re: Weird XFS WAL problem
Re: Weird XFS WAL problem
List pgsql-performance
On Thu, Jun 3, 2010 at 12:40 PM, Kevin Grittner
<Kevin.Grittner@wicourts.gov> wrote:
>
> Yeah, I read that long ago and I've disabled write barriers because
> of it; however, it still seems wrong that the RAID controller
> insists on flushing to the drives in write-back mode.  Here are my
> reasons for wishing it was otherwise:

I think it's a case of the quickest, simplest answer to semi-new tech.
 Not sure what to do with barriers?  Just flush the whole cache.

I'm guessing that this will get optimized in the future.

BTW, I'll have LSI Megaraid latest and greatest to test on in a month,
and older Areca 1680s as well. I'll be updating the firmware on the
arecas, and I'll run some tests on the whole barrier behaviour to see
if it's gotten any better lately.

pgsql-performance by date:

Previous
From: Andy Colson
Date:
Subject: Re: slow query performance
Next
From: "Kevin Grittner"
Date:
Subject: Re: Weird XFS WAL problem