From: Greg Smith <gsmith@gregsmith.com>
To: Mark Wong <markwkm@gmail.com>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Cc: Gabrielle Roth <gorthx@gmail.com>
Cc: Selena Deckelmann <selenamarie@gmail.com>
Subject: Re: Effects of setting linux block device readahead size
Date: Wed, 10 Sep 2008 10:49:06 -0400 (EDT)
Message-ID: <Pine.GSO.4.64.0809101023520.15181@westnet.com> (raw)
In-Reply-To: <70c01d1d0809092353r4ae687a3ycf3d99d43a5680cf@mail.gmail.com>
References: <70c01d1d0809092353r4ae687a3ycf3d99d43a5680cf@mail.gmail.com>
On Tue, 9 Sep 2008, Mark Wong wrote:
> I've started to display the effects of changing the Linux block device
> readahead buffer to the sequential read performance using fio.
Ah ha, told you that was your missing tunable. I'd really like to see the
whole table of one disk numbers re-run when you get a chance. The
reversed ratio there on ext2 (59MB read/92MB write) was what tipped me off
that something wasn't quite right initially, and until that's fixed it's
hard to analyze the rest.
Based on your initial data, I'd say that the two useful read-ahead
settings for this system are 1024KB (conservative but a big improvement)
and 8192KB (point of diminishing returns). The one-disk table you've got
(labeled with what the default read-ahead is) and new tables at those two
values would really flesh out what each disk is capable of.
--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD
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: gsmith@gregsmith.com, markwkm@gmail.com, gorthx@gmail.com, selenamarie@gmail.com
Subject: Re: Effects of setting linux block device readahead size
In-Reply-To: <Pine.GSO.4.64.0809101023520.15181@westnet.com>
* 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