OSDN Git Service

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
tree3f964c7582703912905448873803cb7403f684b5
parentdcbdf9b1d46dc9f95c55f78da4754ded4f0cd17d
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