News for hackers. Stuff that matters.

A comment on Building a faster hash table for high performance SQL joins. Parent comment

Re:Building a faster hash table for high performance SQL joins by mlochbaum on Wednesday December 20, 2023 @05:41PM (#38714629)
Looks like full keys are always compared if hash codes test equal, which is what I'd expect. For example: https://github.com/questdb/questdb/blob/master/core/src/main...
[ Parent | on HN ]
Re:Building a faster hash table for high performance SQL joins by puzpuzpuz-hn on Thursday December 21, 2023 @03:01AM (#38718092)
That's correct. In practice, there is an insignificant amount of hash collisions, so false comparisons are extremely rare.

And thanks for sharing your experience with RH and the links!

[ Parent | on HN ]