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.
From: Josh Berkus [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 23, 2004 12:13 PM
To: Matt Clark; Subbiah, Stalin; 'Andrew Sullivan';
Subject: Re: [PERFORM] [ADMIN] Benchmarking postgres on Solaris/Linux
As for the compute intensive side (complex joins & sorts etc), the Dell
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/
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
far, I've not seen performance that comes even close to the hardware specs.
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend