Re: [PATCHES] updated hash functions for postgresql v1

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [PATCHES] updated hash functions for postgresql v1
Дата
Msg-id 23860.1231612585@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [PATCHES] updated hash functions for postgresql v1  (Jeff Davis <pgsql@j-davis.com>)
Ответы Re: [PATCHES] updated hash functions for postgresql v1  (Jeff Davis <pgsql@j-davis.com>)
Re: [PATCHES] updated hash functions for postgresql v1  (Gregory Stark <stark@enterprisedb.com>)
Re: [PATCHES] updated hash functions for postgresql v1  (Kenneth Marshall <ktm@rice.edu>)
Список 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 по дате отправления:

Предыдущее
От: Heikki Linnakangas
Дата:
Сообщение: Re: [BUGS] BUG #4516: FOUND variable does not work after RETURN QUERY
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [SPAM] Re: posix_fadvise v22