X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 16A8F3B4BD6 for ; Thu, 23 Dec 2004 20:50:24 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 61093-04 for ; Thu, 23 Dec 2004 20:50:16 +0000 (GMT) Received: from floppy.pyrenet.fr (floppy.pyrenet.fr [194.250.190.2]) by svr1.postgresql.org (Postfix) with ESMTP id D9D7E3B4BD1 for ; Thu, 23 Dec 2004 20:50:17 +0000 (GMT) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id 5B32031981; Thu, 23 Dec 2004 21:50:17 +0100 (MET) From: William Yu X-Newsgroups: pgsql.performance Subject: Re: Some Performance Advice Needed Date: Thu, 23 Dec 2004 12:49:09 -0800 Organization: Hub.Org Networking Services Lines: 43 Message-ID: References: <41CAD5C3.6090404@meerkatsoft.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@news.hub.org User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.7.3) Gecko/20040910 X-Accept-Language: en-us, en In-Reply-To: <41CAD5C3.6090404@meerkatsoft.com> To: pgsql-performance@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200412/281 X-Sequence-Number: 9656 Alex wrote: > Hi, > i recently run pgbench against different servers and got some results I > dont quite understand. > > A) EV1: Dual Xenon, 2GHz, 1GB Memory, SCSI 10Krpm, RHE3 > B) Dual Pentium3 1.4ghz (Blade), SCSI Disk 10Krmp, 1GB Memory, Redhat 8 > C) P4 3.2GHz, IDE 7.2Krpm, 1GBMem, Fedora Core2 > > Runnig PGbench reported > A) 220 tps > B) 240 tps > C) 510 tps > > Running hdparm reported > A) 920mb/s (SCSI 10k) > B) 270mb/s (SCSI 10k) > C) 1750mb/s (IDE 7.2k) > > What I dont quite understand is why a P3.2 is twice as fast as a Dual > Xenon with SCSI disks, A dual Xenon 2GHz is not faster than a dual P3 > 1.4Ghz, and the hdparm results also dont make much sense. A few things to clear up about the P3/P4/Xeons. Xeons are P4s. Hence, a P4 2ghz will run the same speed as a Xeon 2ghz assuming all other variables are the same. Of course they aren't because your P4 is probably running unregistered memory, uses either a 533mhz or 800mhz FSB compared to the Xeon's shared 400mhz amongs 2 CPUs, running a faster non-smp kernel. Add all those variables up and it's definitely possible for a P4 3.2ghz to run twice as fast as a Dual Xeon 2ghz on a single-thread benchmark. (The corollary here is that in a multi-thread benchmark, the 2X Xeon can only hope to equal your P4 3.2.) P3s are faster than P4s at the same clock rate. By a lot. It's not really that surprising that a P3 1.4 is faster than a P4/Xeon 2.0. I've seen results like this many times over a wide range of applications. The only variable that is throwing off your comparisons are the hard drives. IDE drives have write caching on by default -- SCSI drives have it off. Use: hdparm -W0 /dev/hda to turn it off on the P4 system and rerun the tests then.