Re: [ADMIN] Benchmarking postgres on Solaris/Linux - Mailing list pgsql-performance

From Subbiah, Stalin
Subject Re: [ADMIN] Benchmarking postgres on Solaris/Linux
Date
Msg-id F1F84A2E5F9EBD46A9BDB905EB5B103937C3@mxca1.netopia.com
Whole thread Raw
List pgsql-performance
Yep. Thanks Bill.

-----Original Message-----
From: Bill Moran [mailto:wmoran@potentialtech.com]
Sent: Tuesday, March 23, 2004 2:10 PM
To: Subbiah, Stalin
Cc: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] [ADMIN] Benchmarking postgres on Solaris/Linux


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

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Fwd: FreeBSD, PostgreSQL, semwait and sbwait!
Next
From: matt@ymogen.net
Date:
Subject: Re: [ADMIN] Benchmarking postgres on Solaris/Linux