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 2FCFCD1B80B for ; Thu, 5 Feb 2004 06:57:11 +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 35290-10 for ; Thu, 5 Feb 2004 02:57:13 -0400 (AST) Received: from unity.basin.cultured.net (24161231hfc249.tampabay.rr.com [24.161.231.249]) by svr1.postgresql.org (Postfix) with ESMTP id 14659D1C9AB for ; Thu, 5 Feb 2004 02:54:19 -0400 (AST) Received: by unity.basin.cultured.net (Postfix, from userid 1000) id 3F7E357BE2; Thu, 5 Feb 2004 01:50:32 -0500 (EST) Subject: Re: 7.3 vs 7.4 performance From: Chris Trawick To: Christopher Browne Cc: pgsql-performance@postgresql.org In-Reply-To: References: <1075958197.2438.330.camel@orthanc> Content-Type: text/plain Content-Transfer-Encoding: 7bit Message-Id: <1075963608.12947.8.camel@unity.basin.cultured.net> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.5 Date: Thu, 05 Feb 2004 01:50:31 -0500 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/70 X-Sequence-Number: 5594 On Thu, 2004-02-05 at 00:32, Christopher Browne wrote: > > Things of note that might matter: the machine is a dual Opteron > > 1.4GHz running Fedora Core 1 Test 1 for X86_64. The 7.3.4 was from > > the Fedora distro and the 7.4.1 was the PGDG package. The database > > is 3.5 Gigs with 10 millions rows and the machine had 1 Gig or ram. > > > > Oh... as a side note I'm happy to announce that the 2.6 Linux kernel > > has more than DOUBLED the speed of all my Postgres queries over the > > 2.4. =) > > I did some heavy-transaction-oriented tests recently on somewhat > heftier quad-Xeon hardware, and found little difference between 2.4 > and 2.6, and a small-but-quite-repeatable advantage with FreeBSD 4.9. > Now, I'm quite sure my load was rather different from yours, but I > find the claim of doubling of speed rather surprising. I don't. I got a similar boost out of 2.6 when dealing with extreme concurrency. Then again, I also got a similar boost out of 7.4. The two together tickled my bank account. ;) One question though... It sounds like your 7.3 binaries are 64-bit and your 7.4 binaries are 32-bit. Have you tried grabbing the SRPM for 7.4 and recompiling it for X86_64? chris