aboutsummaryrefslogtreecommitdiff
path: root/src/tutorial/basics.source
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2005-11-28 23:46:25 +0000
committerTom Lane <tgl@sss.pgh.pa.us>2005-11-28 23:46:25 +0000
commitc4279b45fd6031173adc8ae533a1f81942cfb027 (patch)
treeafcf8e27d6818cc4b5832e7e5eef42cfca43fc48 /src/tutorial/basics.source
parentfc9b777a790eeca33c881c6b11f2b232b3be699d (diff)
downloadpostgresql-c4279b45fd6031173adc8ae533a1f81942cfb027.tar.gz
postgresql-c4279b45fd6031173adc8ae533a1f81942cfb027.zip
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.
Diffstat (limited to 'src/tutorial/basics.source')
0 files changed, 0 insertions, 0 deletions