From: Greg Smith <gsmith@gregsmith.com>
To: pgsql-performance@postgresql.org
Subject: Re: What`s wrong with JFS configuration?
Date: Thu, 26 Apr 2007 00:04:53 -0400 (EDT)
Message-ID: <Pine.GSO.4.64.0704252331040.14007@westnet.com> (raw)
In-Reply-To: <462F59EE.2040801@inea.com.pl>
References: <462EFA63.1030306@inea.com.pl>
<88daf38c0704250555v7a696957x18e62a3d1ae351a7@mail.gmail.com>
<462F59EE.2040801@inea.com.pl>
On Wed, 25 Apr 2007, PaweÅ~B GruszczyÅ~Dski wrote:
> I was just reading some informations on the web (for example:
> http://www.nabble.com/a-comparison-of-ext3,-jfs,-and-xfs-on-hardware-raid-t144738.html).
You were doing your tests with a database scale of 50. As Heikki already
pointed out, that's pretty small (around 800MB) and you're mostly
stressing parts of the system that may not change much based on filesystem
choice. This is even more true when some of your tests are only using a
small amount of transactions in a short period of time, which means just
about everything could still be sitting in memory at the end of the test
with the database disks barely used.
In the example you reference above, a scaling factor of 1000 was used.
This makes for a fairly large database of about 16GB. When running in
that configuration, as stated he's mostly testing seek performance--you
can't hold any significant portion of 16GB in memory, so you're always
moving around the disks to find the data needed. It's a completely
different type of test than what you did.
If you want to try and replicate the filesystem differences shown on that
page, start with the bonnie++ tests and see if you get similar results
there. It's hard to predict whether you'll see the same differences given
how different your RAID setup is from Jeff Baker's tests.
It's not a quick trip from there to check if an improvement there holds up
in database use that's like a real-world load. In addition to addressing
the scaling factor issue, you'll need to so some basic PostgreSQL
parameter tuning from the defaults, think about the impact of checkpoints
on your test, and worry about whether your WAL I/O is being done
efficiently before you get to the point where the database I/O is being
measured usefully at all via pgbench.
--
* 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
Subject: Re: What`s wrong with JFS configuration?
In-Reply-To: <Pine.GSO.4.64.0704252331040.14007@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