From: Sean Chittenden <sean@chittenden.org>
To: Christopher Browne <cbbrowne@acm.org>
Cc: pgsql-performance@postgresql.org
Subject: Re: The results of my PostgreSQL/filesystem performance tests
Date: Thu, 28 Aug 2003 09:12:33 -0700
Message-ID: <20030828161233.GB83759@perrin.nxad.com> (raw)
In-Reply-To: <m3u182gg08.fsf@chvatal.cbbrowne.com>
References: <3F4C0DC4.8070105@potentialtech.com>
<001201c36d24$3c572460$0500a8c0@MOBILE01>
<m3u182gg08.fsf@chvatal.cbbrowne.com>
> What it still leaves quite open is just what happens when the OS has
> more than one disk drive or CPU to play with. It's not clear what
> happens in such cases, whether FreeBSD would catch up, or be "left
> further in the dust." The traditional "propaganda" has been that
> there are all sorts of reasons to expect PostgreSQL on FreeBSD to
> run a bit faster than on Linux; it is a bit unexpected for the
> opposite to seem true.
Let me nip this in the butt before people run away with ideas that
aren't correct. When the tests were performed in FreeBSD 5.1 and
Linux, the hard drives were running UDMA. When running 4.8, for some
reason his drives settled in on PIO mode:
ad0s1a: UDMA ICRC error writing fsbn 1458368 of 729184-729215 (ad0s1 bn 1458368; cn 241 tn 12 sn 44) retrying
ad0s1a: UDMA ICRC error writing fsbn 1458368 of 729184-729215 (ad0s1 bn 1458368; cn 241 tn 12 sn 44) retrying
ad0s1a: UDMA ICRC error writing fsbn 1458368 of 729184-729215 (ad0s1 bn 1458368; cn 241 tn 12 sn 44) retrying
ad0s1a: UDMA ICRC error writing fsbn 1458368 of 729184-729215 (ad0s1 bn 1458368; cn 241 tn 12 sn 44) falling back to PIO mode
The benchmarks were hardly conclusive as UDMA runs vastly faster than
PIO. Until we hear back as to whether cables were jarred loose
between the tests or hearing if something else changed, I'd hardly
consider these conclusive tests given PIO/UDMA is apples to oranges in
terms of speed and I fully expect that FreeBSD 4.8 will perform at
least faster than 5.1 (5.x is still being unwound from Giant), but
should out perform Linux as well if industry experience iss any
indicator.
-sc
--
Sean Chittenden
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-performance@postgresql.org
Cc: sean@chittenden.org, cbbrowne@acm.org
Subject: Re: The results of my PostgreSQL/filesystem performance tests
In-Reply-To: <20030828161233.GB83759@perrin.nxad.com>
References: <3F4C0DC4.8070105@potentialtech.com> <001201c36d24$3c572460$0500a8c0@MOBILE01> <m3u182gg08.fsf@chvatal.cbbrowne.com> <20030828161233.GB83759@perrin.nxad.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