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