pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: markw@osdl.org
To: cott@internetstaff.com
Cc: pgsql-performance@postgresql.org
Subject: Re: PostgreSQL and Linux 2.6 kernel.
Date: Mon, 5 Apr 2004 09:43:36 -0700 (PDT)
Message-ID: <200404051643.i35Ghd200769@mail.osdl.org> (raw)
In-Reply-To: <1081083874.2172.3.camel@localhost.localdomain>

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



view thread (34+ messages)  latest in thread

Message-ID: <200404051643.i35Ghd200769@mail.osdl.org>
Permalink:  ../200404051643.i35Ghd200769@mail.osdl.org/
Also on:    postgresql.org/message-id/200404051643.i35Ghd200769@mail.osdl.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: markw@osdl.org, cott@internetstaff.com
  Subject: Re: PostgreSQL and Linux 2.6 kernel.
  In-Reply-To: <200404051643.i35Ghd200769@mail.osdl.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox