]> granicus.if.org Git - postgresql/commit
Tweak hash join code to use an additional heuristic for deciding whether
authorTom Lane <tgl@sss.pgh.pa.us>
Mon, 28 Nov 2005 23:46:03 +0000 (23:46 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Mon, 28 Nov 2005 23:46:03 +0000 (23:46 +0000)
commit4ab76b1c20500922aebfdd0c26aef4bdcc608e88
tree15520d91328e0773d59e68f756d6f60302b931b9
parentee4aa3021e47584120a019b47859c11d196fba04
Tweak hash join code to use an additional heuristic for deciding whether
it's worth probing the outer relation for emptiness before building the
hash table.  To wit, if we're rescanning a join previously performed,
remember whether we found it nonempty the previous time, and don't bother
with the probe if it was nonempty.  This buys back the performance lost
in examples like Mario Weilguni's.
src/backend/executor/nodeHashjoin.c
src/include/nodes/execnodes.h