pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feeddifferent 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