Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id E650F9F9357 for ; Tue, 12 Dec 2006 02:35:09 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 32191-08 for ; Tue, 12 Dec 2006 02:35:03 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from westnet.com (westnet.com [216.187.52.2]) by postgresql.org (Postfix) with ESMTP id D07CE9F931E for ; Tue, 12 Dec 2006 02:35:04 -0400 (AST) Received: from westnet.com (localhost [127.0.0.1]) by westnet.com (8.13.8/8.13.8) with ESMTP id kBC6Z48Z012327 for ; Tue, 12 Dec 2006 01:35:04 -0500 (EST) Received: from localhost (gsmith@localhost) by westnet.com (8.13.8/8.13.2/Submit) with ESMTP id kBC6Z4lM012324 for ; Tue, 12 Dec 2006 01:35:04 -0500 (EST) X-Authentication-Warning: westnet.com: gsmith owned process doing -bs Date: Tue, 12 Dec 2006 01:35:04 -0500 (EST) From: Greg Smith X-X-Sender: gsmith@westnet.com To: pgsql-performance@postgresql.org Subject: Re: New to PostgreSQL, performance considerations In-Reply-To: <20061212013706.GM16692@mathom.us> Message-ID: References: <87u002mv49.fsf@wolfe.cbbrowne.com> <8a0c7af10612110531sbb019ck259fb16d131fdb50@mail.gmail.com> <60psaq5t94.fsf@dba2.int.libertyrms.com> <20061211173105.GH16692@mathom.us> <20061211184726.GI16692@mathom.us> <457DA782.3060506@modgraph-usa.com> <8a0c7af10612111422x6bdcc0c2p7cbfeb5a7b0e0374@mail.gmail.com> <20061212013706.GM16692@mathom.us> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.151 tagged_above=0 required=5 tests=AWL, BAYES_50, SPF_HELO_PASS, SPF_PASS X-Spam-Level: X-Archive-Number: 200612/274 X-Sequence-Number: 22330 On Mon, 11 Dec 2006, Michael Stone wrote: > Can anyone else reproduce these results? I'm on similar hardware (2.5GHz P4, > 1.5G RAM)... There are two likely candidates for why Daniel's P4 3.0GHz significantly outperforms your 2.5GHz system. 1) Most 2.5GHZ P4 processors use a 533MHz front-side bus (FSB); most 3.0GHZ ones use an 800MHz bus. 2) A typical motherboard paired with a 2.5GHz era processor will have a single-channel memory interface; a typical 3.0GHZ era board supports dual-channel DDR. These changes could easily explain the magnitude of difference in results you're seeing, expecially when combined with a 20% greater raw CPU clock. -- * Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD