Re: [PATCHES] updated hash functions for postgresql v1 - Mailing list pgsql-hackers

From Jeff Davis
Subject Re: [PATCHES] updated hash functions for postgresql v1
Date
Msg-id 1231614438.25019.122.camel@jdavis
Whole thread Raw
In response to Re: [PATCHES] updated hash functions for postgresql v1  (Gregory Stark <stark@enterprisedb.com>)
List pgsql-hackers
On Sat, 2009-01-10 at 13:57 -0500, Gregory Stark wrote:
> But I gather it's a 6% speedup in the time spent actually in the
> hash function.

That's correct. I was not able to detect any difference at all between
the old and new code using HashAggregate, which is where most of my
testing effort went:

http://archives.postgresql.org/message-id/1231531455.25019.75.camel@jdavis

(see test results attached to that message, if you're interested)

I tested with two data distributions and 6 data types.

The 6-10% speedup I saw was a super-micro benchmark testing the hash
function, and I didn't spend much time with that.

Regards,Jeff Davis



pgsql-hackers by date:

Previous
From: "Robert Haas"
Date:
Subject: Re: [SPAM] Re: posix_fadvise v22
Next
From: Stephen Frost
Date:
Subject: Re: New patch for Column-level privileges