OSDN Git Service

Fix cost_nestloop and cost_hashjoin to model the behavior of semi and anti
authorTom Lane <tgl@sss.pgh.pa.us>
Sat, 9 May 2009 22:51:41 +0000 (22:51 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Sat, 9 May 2009 22:51:41 +0000 (22:51 +0000)
commit8dcf18414ba3fd68970fb5095f26bb9f358dedfe
tree286c9dd55543baf5c7887e7d17dc26c43cd0845b
parenta41e9ec0db08dec52be8ee1c27fe55f742e1a8a9
Fix cost_nestloop and cost_hashjoin to model the behavior of semi and anti
joins a bit better, ie, understand the differing cost functions for matched
and unmatched outer tuples.  There is more that could be done in cost_hashjoin
but this already helps a great deal.  Per discussions with Robert Haas.
src/backend/optimizer/path/costsize.c
src/backend/optimizer/plan/createplan.c
src/backend/optimizer/util/restrictinfo.c
src/include/optimizer/restrictinfo.h