Horton

Teach planner how to rearrange join order for some classes of OUTER JOIN.

Tom Lane <tgl@sss.pgh.pa.us>

View on postgr.es
Commit: e3b9852728902bc816bf02574a87eda9a0ca91a1
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date: 2005-12-20T02:30:36Z
Releases: 8.2.0 
Teach planner how to rearrange join order for some classes of OUTER JOIN.
Per my recent proposal.  I ended up basing the implementation on the
existing mechanism for enforcing valid join orders of IN joins --- the
rules for valid outer-join orders are somewhat similar.

Files

PathChange+/−
doc/src/sgml/config.sgml modified +10 −33
doc/src/sgml/perform.sgml modified +28 −13
src/backend/nodes/copyfuncs.c modified +20 −1
src/backend/nodes/equalfuncs.c modified +15 −1
src/backend/nodes/outfuncs.c modified +16 −2
src/backend/optimizer/geqo/geqo_eval.c modified +19 −6
src/backend/optimizer/path/allpaths.c modified +41 −21
src/backend/optimizer/path/joinrels.c modified +190 −158
src/backend/optimizer/plan/initsplan.c modified +314 −128
src/backend/optimizer/plan/planmain.c modified +7 −4
src/backend/optimizer/plan/planner.c modified +3 −12
src/backend/optimizer/prep/prepjointree.c modified +10 −263
src/backend/optimizer/README modified +95 −24
src/backend/optimizer/util/clauses.c modified +131 −3
src/backend/optimizer/util/relnode.c modified +1 −3
src/backend/utils/misc/guc.c modified +3 −3
src/include/nodes/nodes.h modified +2 −1
src/include/nodes/primnodes.h modified +2 −7
src/include/nodes/relation.h modified +37 −10
src/include/optimizer/clauses.h modified +2 −1
src/include/optimizer/paths.h modified +3 −6
src/include/optimizer/planmain.h modified +5 −3
src/include/optimizer/prep.h modified +1 −5