Re: [PATCHES] updated hash functions for postgresql v1
Tom Lane <[email protected]> Sat, 10 Jan 2009 13:36:25 -0500
| Newsgroups | gmane.comp.db.postgresql.devel.general,gmane.comp.db.postgresql.devel.patches |
|---|---|
| Message-ID | <[email protected]> |
Jeff Davis <[email protected]> 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 -- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers