7.3 vs 7.4 performance - Mailing list pgsql-performance

From Orion Henry
Subject 7.3 vs 7.4 performance
Date
Msg-id 1075958197.2438.330.camel@orthanc
Whole thread Raw
Responses Re: 7.3 vs 7.4 performance  (Josh Berkus <josh@agliodbs.com>)
Re: 7.3 vs 7.4 performance  (Hannu Krosing <hannu@tm.ee>)
List pgsql-performance
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?

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. =)



--
Orion Henry <orion@trustcommerce.com>

Attachment

pgsql-performance by date:

Previous
From: Corey Edwards
Date:
Subject: Re: select is not using index?
Next
From: Josh Berkus
Date:
Subject: Re: 7.3 vs 7.4 performance