]> granicus.if.org Git - postgresql/commit
Take OUTER JOIN semantics into account when estimating the size of join
authorTom Lane <tgl@sss.pgh.pa.us>
Fri, 16 Feb 2001 00:03:08 +0000 (00:03 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Fri, 16 Feb 2001 00:03:08 +0000 (00:03 +0000)
commitb29f68f611e26377306a9ba2210a589b472c8544
tree00a057a7682b2a727a9445b753af10dde172a3d4
parentca71c6619086ac3b6e3787c2826363faeab02ac9
Take OUTER JOIN semantics into account when estimating the size of join
relations.  It's not very bright, but at least it now knows that
A LEFT JOIN B must produce at least as many rows as are in A ...
src/backend/optimizer/path/costsize.c
src/backend/optimizer/path/joinrels.c
src/backend/optimizer/util/relnode.c
src/include/optimizer/cost.h
src/include/optimizer/pathnode.h