Re: Dell PowerEdge 2950 performance - Mailing list pgsql-performance

From Bucky Jordan
Subject Re: Dell PowerEdge 2950 performance
Date
Msg-id 78ED28FACE63744386D68D8A9D1CF5D41049DB@MAIL.corp.lumeta.com
Whole thread Raw
In response to Re: Dell PowerEdge 2950 performance  (Vivek Khera <vivek@khera.org>)
Responses Re: Dell PowerEdge 2950 performance
List pgsql-performance
...
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

pgsql-performance by date:

Previous
From: Vivek Khera
Date:
Subject: Re: Dell PowerEdge 2950 performance
Next
From: "Luke Lonergan"
Date:
Subject: Re: Dell PowerEdge 2950 performance