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 A4435D1D885 for ; Thu, 5 Feb 2004 05:28:50 +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 14656-06 for ; Thu, 5 Feb 2004 01:28:52 -0400 (AST) Received: from davinci.ethosmedia.com (server228.ethosmedia.com [209.128.84.228]) by svr1.postgresql.org (Postfix) with ESMTP id 129FBD1C9E1 for ; Thu, 5 Feb 2004 01:28:46 -0400 (AST) Received: from [63.195.55.98] (HELO 192.168.1.29) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.0.2) with ESMTP id 4374202; Wed, 04 Feb 2004 21:29:54 -0800 From: Josh Berkus Reply-To: josh@agliodbs.com Organization: Aglio Database Solutions To: Orion Henry , pgsql-performance@postgresql.org Subject: Re: 7.3 vs 7.4 performance Date: Wed, 4 Feb 2004 21:27:59 -0800 User-Agent: KMail/1.5.4 References: <1075958197.2438.330.camel@orthanc> In-Reply-To: <1075958197.2438.330.camel@orthanc> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200402042127.59134.josh@agliodbs.com> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/68 X-Sequence-Number: 5592 Orion, > I've done some testing of 7.3.4 vs 7.4.1 and found 7.4.1 to be 20%-30% > slower than 7.3.4. Is this common knowledge or am I just unlucky with > my query/data selection? No, it's not common knowledge. It should be the other way around. Perhaps it's the queries you picked? Even so ..... feel free to post individual EXPLAIN ANALYZEs to the list. > 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. I'm wondering if we need specific compile-time switches for Opteron. I know we got Opteron code tweaks in the last version, but am not sure if a --with is required to activate them. > 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. =) Keen. Waiting for upgrades .... -- -Josh Berkus Aglio Database Solutions San Francisco