pgsql/src/backend/optimizer path/allpaths.c pl ...

From: Tom Lane <tgl(at)hub(dot)org>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql/src/backend/optimizer path/allpaths.c pl ...
Date: 2001-01-18 07:12:38
Message-ID: 200101180712.f0I7CcT11289@hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

CVSROOT: /home/projects/pgsql/cvsroot
Module name: pgsql
Changes by: tgl(at)hub(dot)org 01/01/18 02:12:38

Modified files:
src/backend/optimizer/path: allpaths.c
src/backend/optimizer/plan: planner.c

Log message:
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 ...

Browse pgsql-committers by date

  From Date Subject
Next Message Thomas Lockhart 2001-01-18 07:16:56 pgsql/contrib/mysql mysql2pgsql
Previous Message Thomas Lockhart 2001-01-18 07:11:36 pgsql/doc/src/sgml plsql.sgml