Re: Performance with 2 AMD/Opteron 2.6Ghz and 8gig - Mailing list pgsql-performance
From | Leigh Dyer |
---|---|
Subject | Re: Performance with 2 AMD/Opteron 2.6Ghz and 8gig |
Date | |
Msg-id | 44CA1C81.8060703@eclinic.com.au Whole thread Raw |
In response to | Re: Performance with 2 AMD/Opteron 2.6Ghz and 8gig ("Mikael Carneholm" <Mikael.Carneholm@WirelessCar.com>) |
Responses |
Re: Performance with 2 AMD/Opteron 2.6Ghz and 8gig
("Denis Lussier" <denisl@enterprisedb.com>)
|
List | pgsql-performance |
Mikael Carneholm wrote: > 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! > Here's the bonnie++ results from our Sun Fire V40z (2x Opteron 250, 4GB RAM) with 6 15krpm 73GB drives connected to an LSI MegaRAID 320-2X controller with 512MB cache. It's running Linux, and I'm using what seems to be a fairly typical 6-drive setup: 2 drives in RAID-1 for OS and WAL, and 4 drives in RAID-10 for data. This is from the 4-drive RAID-10 array: 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 gaz 8G 56692 88 73061 12 33048 6 44994 64 132571 14 474.0 0 ------Sequential Create------ --------Random Create-------- -Create-- --Read--- -Delete-- -Create-- --Read--- -Delete-- files /sec %CP /sec %CP /sec %CP /sec %CP /sec %CP /sec %CP 16 19448 88 +++++ +++ 18611 72 19952 90 +++++ +++ 15167 65 This system is actually in production currently, and while it's a rather quiet time at the moment, it still wasn't _entirely_ inactive when those numbers were run, so the real performance is probably a little higher. I'll see if I can run some BenchmarkSQL numbers as well. Thanks Leigh > /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 > > > ---------------------------(end of broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match >
pgsql-performance by date: