Buy back some of the cycles spent in more-expensive hash functions by

Tom Lane <tgl@sss.pgh.pa.us>

Commit: bd2c980b229eb5cf411b1d55bf9b26cca34875d7
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date: 2007-06-01T17:38:44Z
Releases: 8.3.0
Buy back some of the cycles spent in more-expensive hash functions by
selecting power-of-2, rather than prime, numbers of buckets in hash joins.
If the hash functions are doing their jobs properly by making all hash bits
equally random, this is good enough, and it saves expensive integer division
and modulus operations.

Files

PathChange+/−
src/backend/executor/nodeHash.c modified +27 −29
src/include/executor/hashjoin.h modified +3 −1