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

I would be interested in what numbers you would get out of bonnie++
(http://www.coker.com.au/bonnie++) and BenchmarkSQL
(http://sourceforge.net/projects/benchmarksql) on that hardware, for
comparison with our DL385 (2xOpteron 280, 16Gb ram) and MSA1500. If you
need help building benchmarksql, I can assist you with that.

Actually, I would be interested if everyone who's reading this that has
a similar machine (2 cpu, dual core opteron) with different storage
systems could send me their bonnie + benchmarksql results!

/Mikael

-----Original Message-----
From: pgsql-performance-owner(at)postgresql(dot)org
[mailto:pgsql-performance-owner(at)postgresql(dot)org] On Behalf Of Luke
Lonergan
Sent: den 28 juli 2006 08:55
To: Kjell Tore Fossbakk; pgsql-performance(at)postgresql(dot)org
Subject: Re: [PERFORM] Performance with 2 AMD/Opteron 2.6Ghz and 8gig

Kjell,

> I got 4 150GIG SCSI disks in a Smart Array 5i 1+0 RAID.

The Smart Array 5i is a terrible performer on Linux. I would be
surprised if you exceed the performance of a single hard drive with this
controller when doing I/O from disk. Since your database working set is
larger than memory on the machine, I would recommend you use a simple
non-RAID U320 SCSI controller, like those from LSI Logic (which HP
resells) and implement Linux software RAID. You should see a nearly 10x
increase in performance as compared to the SmartArray 5i.

If you have a good relationship with HP, please ask them for some
documentation of RAID performance on Linux with the SmartArray 5i. I
predict they will tell you what they've told me and others: "the 5i is
only useful for booting the OS". Alternately they could say: "we have
world record performance with our RAID controllers", in which case you
should ask them if that was with the 5i on Linux or whether it was the
6-series on Windows.

- Luke

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org