diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2004-01-06 04:31:01 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2004-01-06 04:31:01 +0000 |
| commit | b0c4a50bbbbd62c444cb3806a97c1e51e2249cfd (patch) | |
| tree | 0816cf1d1cc2a28665e5de740a20c80afbc4f5e7 /src/backend/optimizer/plan/setrefs.c | |
| parent | fa559a86eec2ae90fd63fd7e6563e42f7dc619e0 (diff) | |
| download | postgresql-b0c4a50bbbbd62c444cb3806a97c1e51e2249cfd.tar.gz postgresql-b0c4a50bbbbd62c444cb3806a97c1e51e2249cfd.zip | |
Instead of rechecking lossy index operators by putting them into the
regular qpqual ('filter condition'), add special-purpose code to
nodeIndexscan.c to recheck them. This ends being almost no net addition
of code, because the removal of planner code balances out the extra
executor code, but it is significantly more efficient when a lossy
operator is involved in an OR indexscan. The old implementation had
to recheck the entire indexqual in such cases.
Diffstat (limited to 'src/backend/optimizer/plan/setrefs.c')
| -rw-r--r-- | src/backend/optimizer/plan/setrefs.c | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/src/backend/optimizer/plan/setrefs.c b/src/backend/optimizer/plan/setrefs.c index 8f64ef1488e..faf4eb29bee 100644 --- a/src/backend/optimizer/plan/setrefs.c +++ b/src/backend/optimizer/plan/setrefs.c @@ -9,7 +9,7 @@ * * * IDENTIFICATION - * $PostgreSQL: pgsql/src/backend/optimizer/plan/setrefs.c,v 1.99 2003/11/29 19:51:50 pgsql Exp $ + * $PostgreSQL: pgsql/src/backend/optimizer/plan/setrefs.c,v 1.100 2004/01/06 04:31:01 tgl Exp $ * *------------------------------------------------------------------------- */ @@ -362,8 +362,8 @@ set_join_references(Join *join, List *rtable) /* * We must fix the inner qpqual too, if it has join - * clauses (this could happen if the index is lossy: some - * indxquals may get rechecked as qpquals). + * clauses (this could happen if special operators are + * involved: some indxquals may get rechecked as qpquals). */ if (NumRelids((Node *) inner_plan->qual) > 1) inner_plan->qual = join_references(inner_plan->qual, |