Обсуждение: Re: [ADMIN] Benchmarking postgres on Solaris/Linux
As anyone done performance benchmark testing with solaris sparc/intel linux. I once read a post here, which had benchmarking test results for using different filesystem like xfs, ext3, ext2, ufs etc. i couldn't find that link anymore and google is failing on me, so anyone have the link handy. Thanks! -----Original Message----- From: Josh Berkus [mailto:josh@agliodbs.com] Sent: Tuesday, March 23, 2004 12:13 PM To: Matt Clark; Subbiah, Stalin; 'Andrew Sullivan'; pgsql-performance@postgresql.org Subject: Re: [PERFORM] [ADMIN] Benchmarking postgres on Solaris/Linux Matt, Stalin, > As for the compute intensive side (complex joins & sorts etc), the Dell will most likely beat the Sun by some distance, although > what the Sun lacks in CPU power it may make up a bit in memory bandwidth/ latency. Personally, I've been unimpressed by Dell/Xeon; I think the Sun might do better than you think, comparitively. On all the Dell servers I've used so far, I've not seen performance that comes even close to the hardware specs. -- -Josh Berkus Aglio Database Solutions San Francisco
On Tue, 2004-03-23 at 12:42, Subbiah, Stalin wrote: > As anyone done performance benchmark testing with solaris sparc/intel linux. > I once read a post here, which had benchmarking test results for using > different filesystem like xfs, ext3, ext2, ufs etc. i couldn't find that > link anymore and google is failing on me, so anyone have the link handy. > > Thanks! This link: http://developer.osdl.org/markw/ takes you to Mark Wong's database developer page. The top set of links shows performance results for Linux kernels running an OLTP workload (dbt-2) under PostgreSQL. He has numbers for ia32 and ia64 under different file system types. To do a "good enough" comparison, one would need to port this test kit to solaris. So far, this kit is only running on Linux. No one, to my knowledge has it running on any other platform. But I suspect there are some working to port the kits. > > -----Original Message----- > From: Josh Berkus [mailto:josh@agliodbs.com] > Sent: Tuesday, March 23, 2004 12:13 PM > To: Matt Clark; Subbiah, Stalin; 'Andrew Sullivan'; > pgsql-performance@postgresql.org > Subject: Re: [PERFORM] [ADMIN] Benchmarking postgres on Solaris/Linux > > > Matt, Stalin, > > > As for the compute intensive side (complex joins & sorts etc), the Dell > will > most likely beat the Sun by some distance, although > > what the Sun lacks in CPU power it may make up a bit in memory bandwidth/ > latency. > > Personally, I've been unimpressed by Dell/Xeon; I think the Sun might do > better than you think, comparitively. On all the Dell servers I've used > so > far, I've not seen performance that comes even close to the hardware specs.
Subbiah, Stalin wrote: > As anyone done performance benchmark testing with solaris sparc/intel linux. > I once read a post here, which had benchmarking test results for using > different filesystem like xfs, ext3, ext2, ufs etc. i couldn't find that > link anymore and google is failing on me, so anyone have the link handy. If you're talking about the work I did, it's here: http://www.potentialtech.com/wmoran/ (then follow the link) Anyway, that should be easily portable to any platform that will run Postgres, but I don't know how useful it is in comparing two different platforms. See the information in the document. It was intended only to test disk access speed, and attempts to flood the HDD system with database work to do. > > Thanks! > > -----Original Message----- > From: Josh Berkus [mailto:josh@agliodbs.com] > Sent: Tuesday, March 23, 2004 12:13 PM > To: Matt Clark; Subbiah, Stalin; 'Andrew Sullivan'; > pgsql-performance@postgresql.org > Subject: Re: [PERFORM] [ADMIN] Benchmarking postgres on Solaris/Linux > > > Matt, Stalin, > > >>As for the compute intensive side (complex joins & sorts etc), the Dell > > will > most likely beat the Sun by some distance, although > >>what the Sun lacks in CPU power it may make up a bit in memory bandwidth/ > > latency. > > Personally, I've been unimpressed by Dell/Xeon; I think the Sun might do > better than you think, comparitively. On all the Dell servers I've used > so > far, I've not seen performance that comes even close to the hardware specs. > -- Bill Moran Potential Technologies http://www.potentialtech.com
Are you talking about http://www.potentialtech.com/wmoran/postgresql.php#conclusion ----- Original Message ----- From: "Subbiah, Stalin" <SSubbiah@netopia.com> To: <josh@agliodbs.com>; "Matt Clark" <matt@ymogen.net>; "Subbiah, Stalin" <SSubbiah@netopia.com>; "'Andrew Sullivan'" <ajs@crankycanuck.ca>; <pgsql-performance@postgresql.org> Sent: Tuesday, March 23, 2004 3:42 PM Subject: Re: [PERFORM] [ADMIN] Benchmarking postgres on Solaris/Linux > As anyone done performance benchmark testing with solaris sparc/intel linux. > I once read a post here, which had benchmarking test results for using > different filesystem like xfs, ext3, ext2, ufs etc. i couldn't find that > link anymore and google is failing on me, so anyone have the link handy. > > Thanks! > > -----Original Message----- > From: Josh Berkus [mailto:josh@agliodbs.com] > Sent: Tuesday, March 23, 2004 12:13 PM > To: Matt Clark; Subbiah, Stalin; 'Andrew Sullivan'; > pgsql-performance@postgresql.org > Subject: Re: [PERFORM] [ADMIN] Benchmarking postgres on Solaris/Linux > > > Matt, Stalin, > > > As for the compute intensive side (complex joins & sorts etc), the Dell > will > most likely beat the Sun by some distance, although > > what the Sun lacks in CPU power it may make up a bit in memory bandwidth/ > latency. > > Personally, I've been unimpressed by Dell/Xeon; I think the Sun might do > better than you think, comparitively. On all the Dell servers I've used > so > far, I've not seen performance that comes even close to the hardware specs. > > -- > -Josh Berkus > Aglio Database Solutions > San Francisco > > ---------------------------(end of broadcast)--------------------------- > TIP 8: explain analyze is your friend >