pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Mark Wong <markw@osdl.org>
To: Josh Berkus <josh@agliodbs.com>
Cc: pgsql-performance@postgresql.org, Bjorn Bength <bjorn.bength@curalia.se>
Subject: Re: different io elevators in linux
Date: Wed, 27 Oct 2004 14:40:48 -0700
Message-ID: <20041027144048.A11433@osdl.org> (raw)
In-Reply-To: <200410251009.17575.josh@agliodbs.com>
References: <1098546845.7754.8.camel@localhost>
	<200410251009.17575.josh@agliodbs.com>

On Mon, Oct 25, 2004 at 10:09:17AM -0700, Josh Berkus wrote:
> Bjorn,
> 
> > I haven't read much FAQs but has anyone done some benchmarks with
> > different io schedulers in linux with postgresql?
> 
> According to OSDL, using the "deadline" scheduler sometimes results in a 
> roughly 5% boost to performance, and sometimes none, depending on the 
> application.   We use it for all testing, though, just in case.
> 
> --Josh
> 

Yes, we found with an OLTP type workload, the as scheduler performs
about 5% worse than the deadline scheduler, where in a DSS type
workload there really isn't much difference.  The former doing a
mix of reading/writing, where the latter is doing mostly reading.

Mark



view thread (3+ messages)

Message-ID: <20041027144048.A11433@osdl.org>
Permalink:  ../20041027144048.A11433@osdl.org/
Also on:    postgresql.org/message-id/20041027144048.A11433@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, josh@agliodbs.com, bjorn.bength@curalia.se
  Subject: Re: different io elevators in linux
  In-Reply-To: <20041027144048.A11433@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