Re: linux deadline i/o elevator tuning - Mailing list pgsql-performance

From Grzegorz Jaśkiewicz
Subject Re: linux deadline i/o elevator tuning
Date
Msg-id 2f4958ff0904090739l547c076fqa06195dfb413cf8b@mail.gmail.com
Whole thread Raw
In response to Re: linux deadline i/o elevator tuning  (Matthew Wakeling <matthew@flymine.org>)
Responses Re: linux deadline i/o elevator tuning
Re: linux deadline i/o elevator tuning
List pgsql-performance
On Thu, Apr 9, 2009 at 3:32 PM, Matthew Wakeling <matthew@flymine.org> wrote:
> On Thu, 9 Apr 2009, Grzegorz Jaśkiewicz wrote:
>>
>> acording to kernel folks, anticipatory scheduler is even better for dbs.
>> Oh well, it probably means everyone has to test it on their own at the
>> end of day.
>
> But the anticipatory scheduler basically makes the huge assumption that you
> have one single disc in the system that takes a long time to seek from one
> place to another. This assumption fails on both RAID arrays and SSDs, so I'd
> be interested to see some numbers to back that one up.

(btw, CFQ is the anticipatory scheduler).

no they not. They only assume that application reads blocks in
synchronous fashion, and that data read in block N will determine
where the N+1 block is going to be.
So to avoid possible starvation problem, it will wait for short amount
of time - in hope that app will want to read possibly next block on
disc, and putting that request at the end of queue could potentially
starve it. (that reason alone is why 2.6 linux feels so much more
responsive).


--
GJ

pgsql-performance by date:

Previous
From: Matthew Wakeling
Date:
Subject: Re: linux deadline i/o elevator tuning
Next
From: "Kevin Grittner"
Date:
Subject: Re: linux deadline i/o elevator tuning