projects / users / c2main / postgres.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: dcbdf9b) | patch
Fix set_joinrel_size_estimates() to estimate outer-join sizes more
authorTom Lane <tgl@sss.pgh.pa.us>
Fri, 10 Nov 2006 01:21:41 +0000 (01:21 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Fri, 10 Nov 2006 01:21:41 +0000 (01:21 +0000)
commitd19798e584c6dd531961b0ced255d4ac382ab84e
tree3f964c7582703912905448873803cb7403f684b5tree
parentdcbdf9b1d46dc9f95c55f78da4754ded4f0cd17dcommit | diff
Fix set_joinrel_size_estimates() to estimate outer-join sizes more
accurately: we have to distinguish the effects of the join's own ON
clauses from the effects of pushed-down clauses.  Failing to do so
was a quick hack long ago, but it's time to be smarter.  Per example
from Thomas H.
src/backend/optimizer/path/costsize.c diff | blob | blame | history
Cedric's Stuff