Re: Performance with 2 AMD/Opteron 2.6Ghz and 8gig

From: Jeff Trout <threshar(at)torgo(dot)978(dot)org>
To: Luke Lonergan <LLonergan(at)greenplum(dot)com>
Cc: "Mikael Carneholm" <Mikael(dot)Carneholm(at)WirelessCar(dot)com>, "Kjell Tore Fossbakk" <kjelltore(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Performance with 2 AMD/Opteron 2.6Ghz and 8gig
Date: 2006-07-28 17:31:21
Message-ID: 7A073C1C-BB04-42C7-A7B9-D25A18DB27D0@torgo.978.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

I too have a DL385 with a single DC Opteron 270.
It claims to have a smart array 6i controller and over the last
couple of days I've been runnign some tests on it, which have been
yielding some suprising results.

I've got 6 10k U320 disks in it. 2 are in a mirror set. We'll not
pay any attention to them.
The remaining 4 disks I've been toying with to see what config works
best, using hardware raid and software raid.

system info:
dl dl385 - 1 opteron 270 - 5GB ram - smart array 6i
cciss0: HP Smart Array 6i Controller
Firmware Version: 2.58
Linux db03 2.6.17-1.2157_FC5 #1 SMP Tue Jul 11 22:53:56 EDT 2006
x86_64 x86_64 x86_64 GNU/Linux
using xfs

Each drive can sustain 80MB/sec read (dd, straight off device)

So here are the results I have so far. (averaged)

hardware raid 5:
dd - write 20GB file - 48MB/sec
dd - read 20GB file - 247MB/sec
[ didn't do a bonnie run on this yet ]
pretty terrible write performance. good read.

hardware raid 10
dd - write 20GB - 104MB/sec
dd - read 20GB - 196MB/sec
bonnie++
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
db03 9592M 45830 97 129501 31 62981 14 48524 99 185818
19 949.0 1

software raid 5
dd - write 20gb - 85MB/sec
dd - read 20gb - 135MB/sec

I was very suprised at those results. I was sort of expecting it to
smoke the hardware. I repeated the test many times, and kept getting
these numbers.

bonnie++:
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
db03 9592M 44110 97 81481 23 34604 10 44495 95 157063
28 919.3 1

software 10:
dd - write - 20GB - 108MB/sec
dd - read - 20GB - 86MB/sec(!!!! WTF? - this is repeatable!!)
bonnie++
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
db03 9592M 44539 98 105444 20 34127 8 39830 83 100374
10 1072 1

so I'm going to be going with hw r5, which went against what I
thought going in - read perf is more important for my usage than write.

I'm still not sure about that software 10 read number. something is
not right there...

--
Jeff Trout <jeff(at)jefftrout(dot)com>
http://www.dellsmartexitin.com/
http://www.stuarthamm.net/

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Mark Lewis 2006-07-28 18:01:54 Re: Performance with 2 AMD/Opteron 2.6Ghz and 8gig
Previous Message Leigh Dyer 2006-07-28 14:17:37 Re: Performance with 2 AMD/Opteron 2.6Ghz and 8gig