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@postgresql.org
[mailto:pgsql-performance-owner@postgresql.org] On Behalf Of Luke
Lonergan
Sent: den 28 juli 2006 08:55
To: Kjell Tore Fossbakk; pgsql-performance@postgresql.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