Re: partition question for new server setup

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Kenneth Marshall <ktm(at)rice(dot)edu>
Cc: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>, Craig James <craig_james(at)emolecules(dot)com>, Whit Armstrong <armstrong(dot)whit(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: partition question for new server setup
Date: 2009-04-28 19:19:36
Message-ID: dcc563d10904281219j33d6b7adyed322a3e6add8b02@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Tue, Apr 28, 2009 at 12:40 PM, Kenneth Marshall <ktm(at)rice(dot)edu> wrote:
> On Tue, Apr 28, 2009 at 01:30:59PM -0500, Kevin Grittner wrote:
>> Craig James <craig_james(at)emolecules(dot)com> wrote:
>>
>> > After a reading various articles, I thought that "noop" was the
>> > right choice when you're using a battery-backed RAID controller.
>> > The RAID controller is going to cache all data and reschedule the
>> > writes anyway, so the kernal schedule is irrelevant at best, and can
>> > slow things down.
>>
>> Wouldn't that depend on the relative sizes of those caches?  In a
>> not-so-hypothetical example, we have machines with 120 GB OS cache,
>> and 256 MB BBU RAID controller cache.  We seem to benefit from
>> elevator=deadline at the OS level.
>>
>> -Kevin
>>
> This was my understanding as well. If your RAID controller had a
> lot of well managed cache, then the noop scheduler was a win. Less
> performant RAID controllers benefit from teh deadline scheduler.

I have an Areca 1680ix with 512M cache on a machine with 32Gig ram and
I get slightly better performance and lower load factors from deadline
than from noop, but it's not by much.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2009-04-28 21:41:21 Re: pg_lock_status() performance
Previous Message Scott Marlowe 2009-04-28 19:17:54 Re: partition question for new server setup