OSDN Git Service

Fix performance issue with qualifications on VIEWs: outer query should
authorTom Lane <tgl@sss.pgh.pa.us>
Thu, 18 Jan 2001 07:12:37 +0000 (07:12 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Thu, 18 Jan 2001 07:12:37 +0000 (07:12 +0000)
commitb06fbc7ad2cb2467a51432c01dd0d0b881667cb9
treebedd2e82f976151ddcfa56da838233adb1c57b53
parent7705581e494d18c1b4796d264b8c7132ed58646f
Fix performance issue with qualifications on VIEWs: outer query should
try to push restrictions on the view down into the view subquery,
so that they can become indexscan quals or what-have-you rather than
being applied at the top level of the subquery.  7.0 and before were
able to do this, though in a much klugier way, and I'd hate to have
anyone complaining that 7.1 is stupider than 7.0 ...
src/backend/optimizer/path/allpaths.c
src/backend/optimizer/plan/planner.c