Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 504F5632D1B for ; Wed, 10 Feb 2010 03:11:43 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 80454-09 for ; Wed, 10 Feb 2010 07:11:30 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-ew0-f222.google.com (mail-ew0-f222.google.com [209.85.219.222]) by mail.postgresql.org (Postfix) with ESMTP id 5EAB5632BC6 for ; Wed, 10 Feb 2010 03:11:32 -0400 (AST) Received: by ewy22 with SMTP id 22so225590ewy.34 for ; Tue, 09 Feb 2010 23:11:31 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:message-id:subject:from:to:cc:content-type :content-transfer-encoding; bh=F5jVnnJSqmMqPfffLyTQto6VJkgFHmKgw4L84yghLjg=; b=oueuDJJkWZ9BlBezNYHcc7gTNQDMY7hnf0kQ/soGs0URt+ZNQm16T5qUYKl3W6H9i3 +k82O5ZWwR/PAa8YoW8oBODagfWrtnlLtl23VTpWpL24ZNkEg5b0i26RHICuu6Cezx3t UL7dvoQk2kRTWwddmejLCrQMDNq4zEX+IbsYY= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type:content-transfer-encoding; b=etwIDf44eFEsFcCFVOcQKP3++1zh6Vom3j0NzoU/6OTbq+8ae0jyp+bd2YduNYx5Fl afRIciQY0RttgItqAZJ5VUzWVjfByt8vI6Z6t1dhgTc/RQ7O3oVMPn7gXBWskqfh0UWl GCvlSBBYyfTeKfZlaAghuH6JQa6qO1BAfldrA= MIME-Version: 1.0 Received: by 10.216.89.131 with SMTP id c3mr777331wef.197.1265785890824; Tue, 09 Feb 2010 23:11:30 -0800 (PST) In-Reply-To: <4B725410.5010000@2ndquadrant.com> References: <4B6FDD26.9010106@2ndquadrant.com> <4B6FD868020000250002F084@gw.wicourts.gov> <4B702E05.1000708@2ndquadrant.com> <1265652529.2153.13.camel@hvost> <4B70E18D.2040709@2ndquadrant.com> <39DDB34B-C375-46ED-83D2-688A32188100@torgo.978.org> <4B725410.5010000@2ndquadrant.com> Date: Wed, 10 Feb 2010 00:11:30 -0700 Message-ID: Subject: Re: Linux I/O tuning: CFQ vs. deadline From: Scott Marlowe To: Greg Smith Cc: Jeff , david@lang.hm, Hannu Krosing , Kevin Grittner , pgsql-performance@postgresql.org, Albe Laurenz Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.481 tagged_above=-10 required=5 tests=AWL=0.118, BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 201002/152 X-Sequence-Number: 37573 On Tue, Feb 9, 2010 at 11:37 PM, Greg Smith wrote: > Jeff wrote: >> >> I'd done some testing a while ago on the schedulers and at the time >> deadline or noop smashed cfq. =A0Now, it is 100% possible since then tha= t >> they've made vast improvements to cfq and or the VM to get better or sim= ilar >> performance. =A0I recall a vintage of 2.6 where they severely messed up = the >> VM. Glad I didn't upgrade to that one :) >> >> Here's the old post: >> http://archives.postgresql.org/pgsql-performance/2008-04/msg00155.php > > pgiosim doesn't really mix writes into there though, does it? =A0The mixe= d > read/write situations are the ones where the scheduler stuff gets messy. I agree. I think the only way to really test it is by testing it against the system it's got to run under. I'd love to see someone do a comparison of early to mid 2.6 kernels (2.6.18 like RHEL5) to very up to date 2.6 kernels. On fast hardware. What it does on a laptop isn't that interesting and I don't have a big machine idle to test it on.