pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Orion Henry <orion@trustcommerce.com>
To: pgsql-performance@postgresql.org
Subject: 7.3 vs 7.4 performance
Date: 04 Feb 2004 21:16:37 -0800
Message-ID: <1075958197.2438.330.camel@orthanc> (raw)

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>

Attachments:

  signature.asc (application/pgp-signature, 188B) download

view thread (16+ messages)  latest in thread

Message-ID: <1075958197.2438.330.camel@orthanc>
Permalink:  ../1075958197.2438.330.camel@orthanc/
Also on:    postgresql.org/message-id/1075958197.2438.330.camel@orthanc

 · 

reply

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: orion@trustcommerce.com
  Subject: Re: 7.3 vs 7.4 performance
  In-Reply-To: <1075958197.2438.330.camel@orthanc>

* 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