Re: Linux I/O tuning: CFQ vs. deadline

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Greg Smith *EXTERN*" <greg(at)2ndquadrant(dot)com>, <pgsql-performance(at)postgresql(dot)org>, "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at>
Subject: Re: Linux I/O tuning: CFQ vs. deadline
Date: 2010-02-08 15:24:56
Message-ID: 4B6FD868020000250002F084@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at> wrote:
> Greg Smith wrote:

>> http://insights.oetiker.ch/linux/fsopbench/
>
> That is interesting; particularly since I have made one quite
> different experience in which deadline outperformed CFQ by a
> factor of approximately 4.

I haven't benchmarked it per se, but when we started using
PostgreSQL on Linux, the benchmarks and posts I could find
recommended deadline=elevator, so we went with that, and when the
setting was missed on a machine it was generally found fairly
quickly because people complained that the machine wasn't performing
to expectations; changing this to deadline corrected the problem.

> So I tried to look for differences, and I found two possible
> places:
> - My test case was read-only, our production system is
> read-mostly.

Yeah, our reads are typically several times our writes -- up to
maybe 10 to 1.

> - We did not have a RAID array, but a SAN box (with RAID inside).

No SAN here, but if I recall correctly, this was mostly an issue on
our larger arrays -- RAID 5 with dozens of spindles on a BBU
hardware controller.

Other differences between our environment and that of the benchmarks
cited above:

- We use SuSE Linux Enterprise Server, so we've been on *much*
earlier kernel versions that this benchmark.

- We've been using xfs, with noatime,nobarrier.

I'll keep this in mind as something to try if we have problem
performance in line with what that page describes, though....

-Kevin

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Greg Smith 2010-02-08 15:30:13 Re: Linux I/O tuning: CFQ vs. deadline
Previous Message Albe Laurenz 2010-02-08 14:57:25 Re: Linux I/O tuning: CFQ vs. deadline