Restructure planning of nestloop inner indexscans so that the set of usable
Tom Lane <tgl@sss.pgh.pa.us>
Restructure planning of nestloop inner indexscans so that the set of usable joinclauses is determined accurately for each join. Formerly, the code only considered joinclauses that used all of the rels from the outer side of the join; thus for example FROM (a CROSS JOIN b) JOIN c ON (c.f1 = a.x AND c.f2 = b.y) could not exploit a two-column index on c(f1,f2), since neither of the qual clauses would be in the joininfo list it looked in. The new code does this correctly, and also is able to eliminate redundant clauses, thus fixing the problem noted 24-Oct-02 by Hans-Jürgen Schönig.
Files
| Path | Change | +/− |
|---|---|---|
| src/backend/nodes/copyfuncs.c | modified | +29 −4 |
| src/backend/nodes/equalfuncs.c | modified | +20 −11 |
| src/backend/nodes/list.c | modified | +41 −1 |
| src/backend/nodes/outfuncs.c | modified | +3 −7 |
| src/backend/nodes/readfuncs.c | modified | +1 −8 |
| src/backend/optimizer/path/indxpath.c | modified | +464 −312 |
| src/backend/optimizer/path/joinpath.c | modified | +3 −68 |
| src/backend/optimizer/path/orindxpath.c | modified | +1 −4 |
| src/backend/optimizer/path/tidpath.c | modified | +1 −41 |
| src/backend/optimizer/plan/initsplan.c | modified | +6 −9 |
| src/backend/optimizer/util/pathnode.c | modified | +3 −6 |
| src/backend/optimizer/util/plancat.c | modified | +5 −1 |
| src/backend/optimizer/util/relnode.c | modified | +8 −58 |
| src/backend/optimizer/util/restrictinfo.c | modified | +82 −5 |
| src/include/nodes/nodes.h | modified | +2 −1 |
| src/include/nodes/pg_list.h | modified | +2 −1 |
| src/include/nodes/relation.h | modified | +64 −40 |
| src/include/optimizer/paths.h | modified | +3 −1 |
| src/include/optimizer/restrictinfo.h | modified | +4 −1 |