pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Orion Henry <orion@trustcommerce.com>
To: Hannu Krosing <hannu@tm.ee>
Cc: Christopher Browne <cbbrowne@acm.org>
Cc: pgsql-performance@postgresql.org
Subject: Re: 7.3 vs 7.4 performance
Date: 06 Feb 2004 17:03:26 -0800
Message-ID: <1076115806.3377.122.camel@orthanc> (raw)
In-Reply-To: <1076064299.2546.9.camel@fuji.krosing.net>
References: <1075958197.2438.330.camel@orthanc>
	<m3smhqm6qv.fsf@wolfe.cbbrowne.com>
	<1076064299.2546.9.camel@fuji.krosing.net>

On Fri, 2004-02-06 at 02:44, Hannu Krosing wrote:
> Christopher Browne kirjutas N, 05.02.2004 kell 07:32:
> > Oops! orion@trustcommerce.com (Orion Henry) was seen spray-painting on a wall:
> > > 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.
> 
> perhaps you were just IO-bound while he was not ?
> 
> or starving on some locks ?

The queries were across almost 4 gigs of data on a machine with 512 MB of ram.
I personally was assuming it was the anticipatory disk scheduler... but alas I 
don't know why it affected me so much.

Attachments:

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

view thread (16+ messages)  latest in thread

Message-ID: <1076115806.3377.122.camel@orthanc>
Permalink:  ../1076115806.3377.122.camel@orthanc/
Also on:    postgresql.org/message-id/1076115806.3377.122.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, hannu@tm.ee, cbbrowne@acm.org
  Subject: Re: 7.3 vs 7.4 performance
  In-Reply-To: <1076115806.3377.122.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