From: Josh Berkus <josh@agliodbs.com>
To: Orion Henry <orion@trustcommerce.com>
To: pgsql-performance@postgresql.org
Subject: Re: 7.3 vs 7.4 performance
Date: Wed, 4 Feb 2004 21:27:59 -0800
Message-ID: <200402042127.59134.josh@agliodbs.com> (raw)
In-Reply-To: <1075958197.2438.330.camel@orthanc>
References: <1075958197.2438.330.camel@orthanc>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: josh@agliodbs.com, orion@trustcommerce.com
Subject: Re: 7.3 vs 7.4 performance
In-Reply-To: <200402042127.59134.josh@agliodbs.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox