Re: [ADMIN] Benchmarking postgres on Solaris/Linux

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(at)agliodbs(dot)com]
> Sent: Tuesday, March 23, 2004 12:13 PM
> To: Matt Clark; Subbiah, Stalin; 'Andrew Sullivan';
> pgsql-performance(at)postgresql(dot)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.