Adjust the definition of RestrictInfo's left_relids and right_relids
Tom Lane <tgl@sss.pgh.pa.us>
Adjust the definition of RestrictInfo's left_relids and right_relids fields: now they are valid whenever the clause is a binary opclause, not only when it is a potential join clause (there is a new boolean field canjoin to signal the latter condition). This lets us avoid recomputing the relid sets over and over while examining indexes. Still more work to do to make this as useful as it could be, because there are places that could use the info but don't have access to the RestrictInfo node.
Files
| Path | Change | +/− |
|---|---|---|
| src/backend/nodes/copyfuncs.c | modified | +4 −3 |
| src/backend/nodes/equalfuncs.c | modified | +3 −10 |
| src/backend/nodes/outfuncs.c | modified | +3 −2 |
| src/backend/optimizer/path/indxpath.c | modified | +31 −22 |
| src/backend/optimizer/path/joinpath.c | modified | +5 −5 |
| src/backend/optimizer/plan/initsplan.c | modified | +23 −19 |
| src/backend/optimizer/util/clauses.c | modified | +15 −1 |
| src/backend/optimizer/util/restrictinfo.c | modified | +4 −10 |
| src/include/nodes/relation.h | modified | +14 −10 |
| src/include/optimizer/clauses.h | modified | +2 −1 |