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 7BAD9D1DAE9 for ; Tue, 23 Mar 2004 20:53:43 +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 83718-07 for ; Tue, 23 Mar 2004 16:53:43 -0400 (AST) Received: from bayswater1.ymogen.net (host-154-240-27-217.pobox.net.uk [217.27.240.154]) by svr1.postgresql.org (Postfix) with ESMTP id 53F63D1D287 for ; Tue, 23 Mar 2004 16:53:41 -0400 (AST) Received: by bayswater1.ymogen.net (Postfix, from userid 99) id 9B1DC9AD48; Tue, 23 Mar 2004 20:53:42 +0000 (GMT) Received: from 82.68.132.233 (SquirrelMail authenticated user matt@ymogen.net) by webmail.ymogen.com with HTTP; Tue, 23 Mar 2004 20:53:42 -0000 (GMT) Message-ID: <1356.82.68.132.233.1080075222.squirrel@webmail.ymogen.com> In-Reply-To: <200403231213.29342.josh@agliodbs.com> References: <200403231213.29342.josh@agliodbs.com> Date: Tue, 23 Mar 2004 20:53:42 -0000 (GMT) Subject: Re: [ADMIN] Benchmarking postgres on Solaris/Linux From: matt@ymogen.net To: josh@agliodbs.com Cc: "Subbiah, Stalin" , "'Andrew Sullivan'" , pgsql-performance@postgresql.org User-Agent: SquirrelMail/1.4.2-0.1.7.x MIME-Version: 1.0 Content-Type: text/plain;charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Priority: 3 Importance: Normal X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/327 X-Sequence-Number: 6183 > 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. It's true that any difference will be far less than the GHz ratio, and I can't really speak for Dell servers in general, but a pair of 2.4GHz Xeons in a Dell workstation gets about 23 SPECint_rate2000, and a pair of 1GHz UltraSparc IIIs in a SunFire V210 gets 10. The ratios are the same for other non-FP benchmarks. Now the Suns do have some architectural advantages, and they used to have far superior memory bandwidth than intel boxes, and they often still do for more than 2 cpus, and definitely do for more than four. But my personal experience is that for 4 cpus or less the entry level UNIX offerings from Sun/IBM/HP fell behind in raw performance (FP excepted) two or three years ago. The posh hardware's an entirely different matter of course. On the other hand, I can think of innumerable non performance related reasons to buy a 'real UNIX box' as a low end DB server. CPU performance is way down the priority list compared with IO throughput, stability, manageability, support, etc etc. Given that the original question was about a very heavily write-oriented environment, I'd take the Sun every day of the week, assuming that those compile option changes have sorted out the oddly slow PG performance at last. M