From: David Rees <drees76@gmail.com>
To: Peter Schuller <peter.schuller@infidyne.com>
To: pgsql-performance@postgresql.org
Subject: Re: Occasional Slow Commit
Date: Thu, 6 Nov 2008 07:47:27 -0800
Message-ID: <72dbd3150811060747u7f3c2aadv3c6658d285d74455@mail.gmail.com> (raw)
In-Reply-To: <20081106102147.GB70379@hyperion.scode.org>
References: <72dbd3150810271723w57859013v9c4e3718ae86fba@mail.gmail.com>
<Pine.GSO.4.64.0810290906150.19233@westnet.com>
<72dbd3150810291530q7a95da64j2c39354de9ad91d1@mail.gmail.com>
<72dbd3150810311714s51639bc3kfdbe03a7b51bc55c@mail.gmail.com>
<72dbd3150811051925n50ead40cn30354990ebb8bfb6@mail.gmail.com>
<20081106102147.GB70379@hyperion.scode.org>
On Thu, Nov 6, 2008 at 2:21 AM, Peter Schuller
<peter.schuller@infidyne.com> wrote:
>> I also found that my write cache was set to WriteThrough instead of
>> WriteBack, defeating the purpose of having a BBU and that my secondary
>> server apparently doesn't have a BBU on it. :-(
>
> Note also that several RAID controllers will periodically drop the
> write-back mode during battery capacity tests. If you care about
> consistently/deterministically having full performance (with
> white-backed battery protected caching), you probably want to confirm
> your controller behavior here.
>
> (I've seen this on at least LSI based controllers in Dell 2950:s, and
> also on some 3wares.)
I can confirm that this is the case by reviewing the logs stored on
the MegaRAID controller that have a BBU and had WriteBack configured.
The controller also lets you know (using the MegaCli utility) what
setting is configured, and what setting is in effect.
In the case of the machines without a BBU on them, they are configured
to be in WriteBack, but are actually running in WriteThrough.
-Dave
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: drees76@gmail.com, peter.schuller@infidyne.com
Subject: Re: Occasional Slow Commit
In-Reply-To: <72dbd3150811060747u7f3c2aadv3c6658d285d74455@mail.gmail.com>
* 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