]> granicus.if.org Git - postgresql/commit
Improve hash join to discard input tuples immediately if they can't
authorTom Lane <tgl@sss.pgh.pa.us>
Sun, 28 Jan 2007 23:21:26 +0000 (23:21 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Sun, 28 Jan 2007 23:21:26 +0000 (23:21 +0000)
commitb39e91501c101d67b92f3e6965da5dc111195f52
tree1820d8ba0289c5e32a025b9f62bdd98ca494a972
parent28c480e9ae64fc239fa1ebe32a981312e65ae1e7
Improve hash join to discard input tuples immediately if they can't
match because they contain a null join key (and the join operator is
known strict).  Improves performance significantly when the inner
relation contains a lot of nulls, as per bug #2930.
src/backend/executor/nodeHash.c
src/backend/executor/nodeHashjoin.c
src/include/executor/hashjoin.h
src/include/executor/nodeHash.h