From: Rory Campbell-Lange <rory@campbell-lange.net>
To: Steve Poe <spoe@sfnet.cc>
Cc: pgsql-performance@postgresql.org
Subject: Re: Disk tests for a new database server
Date: Thu, 8 Dec 2005 22:56:20 +0000
Message-ID: <20051208225620.GA14485@campbell-lange.net> (raw)
In-Reply-To: <1134054391.10837.3.camel@amd64-gentoo-laptop>
References: <20051208121259.GA29104@campbell-lange.net>
<1134054391.10837.3.camel@amd64-gentoo-laptop>
Hi Steve
On 08/12/05, Steve Poe (spoe@sfnet.cc) wrote:
> Rory,
>
> While I don't have my specific stats with my from my tests with XFS and
> bonnie for our company's db server, I do recall vividly that seq. output
> did not increase dramatically until I had 8+ discs in a RAID10
> configuration on an LSI card. I was not using LVM. If I had less than 8
> discs, seq. output was about equal regardless of file system being uses
> (EXT3,JFS,or XFS).
Thanks for the information. I certainly had not appreciated this fact.
Regards,
Rory
> On Thu, 2005-12-08 at 12:12 +0000, Rory Campbell-Lange wrote:
> > We are testing disk I/O on our new server (referred to in my recent
> > questions about LVM and XFS on this list) and have run bonnie++ on the
> > xfs partition destined for postgres; results noted below.
> >
> > I haven't been able to find many benchmarks showing desirable IO stats.
> > As far as I can tell the sequential input (around 110000K/sec) looks
> > good while the sequential output (around 50000K/sec) looks fairly
> > average.
> >
> > Advice and comments gratefully received.
> > Suggested Parameters for running pg_bench would be great!
> >
> > Thanks,
> > Rory
...
> > Version 1.03 ------Sequential Output------ --Sequential Input- --Random-
> > -Per Chr- --Block-- -Rewrite- -Per Chr- --Block-- --Seeks--
> > Machine Size K/sec %CP K/sec %CP K/sec %CP K/sec %CP K/sec %CP /sec %CP
> > mas 13000M 52655 99 52951 10 32246 7 41441 72 113438 12 590.0 0
> > mas 13000M 49306 83 51967 9 32269 7 42442 70 115427 12 590.5 1
> > mas 13000M 53449 89 51982 10 32625 7 42819 71 111829 11 638.3 0
> > mas 13000M 51818 88 51639 9 33127 7 42377 70 108585 11 556.5 0
...
> > ------Sequential Create------ --------Random Create--------
> > -Create-- --Read--- -Delete-- -Create-- --Read--- -Delete--
> > files:max:min /sec %CP /sec %CP /sec %CP /sec %CP /sec %CP /sec %CP
> > mas 16 7970 36 +++++ +++ 7534 34 7918 36 +++++ +++ 4482 22
> > mas 16 7945 33 +++++ +++ 7483 30 7918 42 +++++ +++ 4438 20
> > mas 16 8481 48 +++++ +++ 7468 31 7870 39 +++++ +++ 4385 23
> > mas 16 7915 36 +++++ +++ 7498 33 7930 41 +++++ +++ 4619 23
> > mas 16 8553 35 +++++ +++ 8312 38 8613 37 +++++ +++ 4513 24
> > mas 16 8498 40 +++++ +++ 8215 33 8570 43 +++++ +++ 4858 26
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: rory@campbell-lange.net, spoe@sfnet.cc
Subject: Re: Disk tests for a new database server
In-Reply-To: <20051208225620.GA14485@campbell-lange.net>
* 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