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

From Tom Lane
Subject Re: [PATCHES] updated hash functions for postgresql v1
Date
Msg-id 23860.1231612585@sss.pgh.pa.us
Whole thread Raw
In response to Re: [PATCHES] updated hash functions for postgresql v1  (Jeff Davis <pgsql@j-davis.com>)
Responses Re: [PATCHES] updated hash functions for postgresql v1
Re: [PATCHES] updated hash functions for postgresql v1
Re: [PATCHES] updated hash functions for postgresql v1
List pgsql-hackers
Jeff Davis <pgsql@j-davis.com> writes:
> I ran 5 times on both old and new code, eliminating the top and bottom
> and taking the average of the remaining 3, and I got a 6.9% performance
> improvement with the new code.

The question that has been carefully evaded throughout the discussion
of this patch is whether the randomness of the hash result is decreased,
and if so what is that likely to cost us in performance of the various
hash-dependent algorithms.  I would still like to have an answer to that
before we make a change to gain marginal performance improvement in
the hash function itself (which is already shown to be barely measurable
in the total context of a hash-dependent operation...)
        regards, tom lane


pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: [BUGS] BUG #4516: FOUND variable does not work after RETURN QUERY
Next
From: Tom Lane
Date:
Subject: Re: [SPAM] Re: posix_fadvise v22