pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
different io elevators in linux
3+ messages / 3 participants
[nested] [flat]

* different io elevators in linux
@ 2004-10-23 15:54  Bjorn Bength <bjorn.bength@curalia.se>
  0 siblings, 1 reply; 3+ messages in thread

From: Bjorn Bength @ 2004-10-23 15:54 UTC (permalink / raw)
  To: pgsql-performance

I haven't read much FAQs but has anyone done some benchmarks with
different io schedulers in linux with postgresql?

Look at these:
http://kerneltrap.org/node/view/843
http://simonraven.nuit.ca/blog/archives/2004/05/20/quikconf/


Maybe its well known knowledge but i just found this information and
haven't had time to do my own testing yet.

mvh

-- 
Björn Bength  |  Systems Designer
--
Curalia AB  |  www.curalia.se
Tjärhovsgatan 21, SE - 116 28 Stockholm, Sweden
Phone: +46 (0)8-410 064 40
--




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: different io elevators in linux
@ 2004-10-25 17:09  Josh Berkus <josh@agliodbs.com>
  parent: Bjorn Bength <bjorn.bength@curalia.se>
  0 siblings, 1 reply; 3+ messages in thread

From: Josh Berkus @ 2004-10-25 17:09 UTC (permalink / raw)
  To: pgsql-performance; +Cc: Bjorn Bength <bjorn.bength@curalia.se>

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

-- 
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: different io elevators in linux
@ 2004-10-27 21:40  Mark Wong <markw@osdl.org>
  parent: Josh Berkus <josh@agliodbs.com>
  0 siblings, 0 replies; 3+ messages in thread

From: Mark Wong @ 2004-10-27 21:40 UTC (permalink / raw)
  To: Josh Berkus <josh@agliodbs.com>; +Cc: pgsql-performance@postgresql.org, Bjorn Bength <bjorn.bength@curalia.se>

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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2004-10-27 21:40 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-10-23 15:54 different io elevators in linux Bjorn Bength <bjorn.bength@curalia.se>
2004-10-25 17:09 ` Josh Berkus <josh@agliodbs.com>
2004-10-27 21:40   ` Mark Wong <markw@osdl.org>

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