X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 1FEB3D1E9CF for ; Mon, 5 Apr 2004 16:43:13 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 50730-04 for ; Mon, 5 Apr 2004 13:43:41 -0300 (ADT) Received: from mail.osdl.org (fw.osdl.org [65.172.181.6]) by svr1.postgresql.org (Postfix) with ESMTP id B49FBD1E9C5 for ; Mon, 5 Apr 2004 13:43:09 -0300 (ADT) Received: from osdl.org (markw@ibm-b.pdx.osdl.net [172.20.1.51]) by mail.osdl.org (8.11.6/8.11.6) with ESMTP id i35Ghd200769; Mon, 5 Apr 2004 09:43:40 -0700 Message-Id: <200404051643.i35Ghd200769@mail.osdl.org> Date: Mon, 5 Apr 2004 09:43:36 -0700 (PDT) From: markw@osdl.org Subject: Re: PostgreSQL and Linux 2.6 kernel. To: cott@internetstaff.com Cc: pgsql-performance@postgresql.org In-Reply-To: <1081083874.2172.3.camel@localhost.localdomain> MIME-Version: 1.0 Content-Type: TEXT/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/41 X-Sequence-Number: 6341 On 4 Apr, Cott Lang wrote: > On Sun, 2004-04-04 at 01:56, Gary Doades wrote: >> Unfortunately I don't understand the question! >> >> My background is the primarily Win32. The last time I used a *nix OS >> was about 20 years ago apart from occasional dips into the linux OS >> over the past few years. If you can tell be how to find out what you want >> I will gladly give you the information. > > There are two available io schedulers in 2.6 (new feature), deadline and > anticipatory. It should show be listed in the boot messages: > > dmesg | grep scheduler > > I've seen people arguing for each of the two schedulers, saying one is > better than the other for databases. I'm curious which one you're > using. :) Our database tests (TPC fair use implementations) show that the deadline scheduler has an edge on the anticipatory scheduler. Depending on the current state of the AS scheduler, it can be within a few percent to 10% or so. I have some data with one of our tests here: http://developer.osdl.org/markw/fs/dbt2_project_results.html Mark