pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Luke Lonergan <llonergan@greenplum.com>
To: Bucky Jordan <bjordan@lumeta.com>
To: Vivek Khera <vivek@khera.org>
To: Pgsql-Performance ((E-mail)) <pgsql-performance@postgresql.org>
Subject: Re: Dell PowerEdge 2950 performance
Date: Mon, 14 Aug 2006 22:23:13 -0700
Message-ID: <C106A851.2E2DE%llonergan@greenplum.com> (raw)
In-Reply-To: <78ED28FACE63744386D68D8A9D1CF5D41049DB@MAIL.corp.lumeta.com>

Bucky,

I see you are running bonnie++ version 1.93c. The numbers it reports are
very different from version 1.03a, which is the one everyone runs - can you
post your 1.03a numbers from bonnie++?

- Luke


On 8/14/06 4:38 PM, "Bucky Jordan" <bjordan@lumeta.com> wrote:

> ...
> Of more interest would be a test which involved large files with lots
> of seeks all around (something like bonnie++ should do that).
> ...
> 
> Here's the bonnie++ numbers for the RAID 5 x 6 disks. I believe this was
> with write-through and 64k striping. I plan to run a few others with
> different block sizes and larger files- I'd be happy to send out a link
> to the list when I get a chance to post them somewhere. I've also been
> running some basic tests with pgbench just to help jumpstart customizing
> postgresql.conf, so that might be of interest too.
> 
> bash-2.05b$ bonnie++ -d bonnie -s 1000:8k
> Version 1.93c       ------Sequential Output------ --Sequential Input-
> --Random-
> Concurrency   1     -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
>              1000M   587  99 246900  71 225124  76  1000  99 585723  99
> 8573 955
> Latency             14367us   50829us     410ms   57965us    1656us
> 432ms
> Version 1.93c       ------Sequential Create------ --------Random
> Create--------
>                     -Create-- --Read--- -Delete-- -Create-- --Read---
> -Delete--
>               files  /sec %CP  /sec %CP  /sec %CP  /sec %CP  /sec %CP
> /sec %CP
>                  16 28192  91 +++++ +++ +++++ +++ 26076  89 +++++ +++
> +++++ +++
> Latency             25988us      75us      37us   24756us      36us
> 41us
> 1.93c,1.93c,
> ,1,1155223901,1000M,,587,99,246900,71,225124,76,1000,99,585723,99,8573,9
> 55,16,,,,,28192,91,+++++,+++,+++++,+++,26076,89,+++++,+++,+++++,+++,1436
> 7us,50829us,410ms,57965us,1656us,432ms,25988us,75us,37us,24756us,36us,41
> us
> 
> ...
> Thanks for sharing your numbers.
> ...
> 
> You're welcome- I prefer to see actual numbers rather than people simply
> stating that RAID controller X is better, so hopefully more people will
> do the same.
> 
> - Bucky
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
> 





view thread (14+ messages)  latest in thread

Message-ID: <C106A851.2E2DE%llonergan@greenplum.com>
Permalink:  ../C106A851.2E2DE%25llonergan@greenplum.com/
Also on:    postgresql.org/message-id/C106A851.2E2DE%llonergan@greenplum.com

 · 

reply

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: llonergan@greenplum.com, bjordan@lumeta.com, vivek@khera.org
  Subject: Re: Dell PowerEdge 2950 performance
  In-Reply-To: <C106A851.2E2DE%llonergan@greenplum.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