X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id E9B20D1EC0F for ; Tue, 23 Mar 2004 20:42:36 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 80887-03 for ; Tue, 23 Mar 2004 16:42:35 -0400 (AST) Received: from mxca1.netopia.com (host222.netopia.com [65.206.239.222]) by svr1.postgresql.org (Postfix) with ESMTP id D3A4FD1EC64 for ; Tue, 23 Mar 2004 16:42:33 -0400 (AST) Received: by mxca1.netopia.com with Internet Mail Service (5.5.2657.72) id ; Tue, 23 Mar 2004 12:42:35 -0800 Message-ID: From: "Subbiah, Stalin" To: "'josh@agliodbs.com'" , Matt Clark , "Subbiah, Stalin" , 'Andrew Sullivan' , pgsql-performance@postgresql.org Subject: Re: [ADMIN] Benchmarking postgres on Solaris/Linux Date: Tue, 23 Mar 2004 12:42:33 -0800 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2657.72) Content-Type: text/plain; charset="ISO-8859-1" X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/325 X-Sequence-Number: 6181 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