pgsql: Improve my initial, rather hacky implementation of joins to

From: tgl(at)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Improve my initial, rather hacky implementation of joins to
Date: 2006-02-05 02:59:17
Message-ID: 20060205025917.6D6099DCAC9@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Log Message:
-----------
Improve my initial, rather hacky implementation of joins to append
relations: fix the executor so that we can have an Append plan on the
inside of a nestloop and still pass down outer index keys to index scans
within the Append, then generate such plans as if they were regular
inner indexscans. This avoids the need to evaluate the outer relation
multiple times.

Modified Files:
--------------
pgsql/src/backend/commands:
explain.c (r1.142 -> r1.143)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/explain.c.diff?r1=1.142&r2=1.143)
pgsql/src/backend/executor:
nodeAppend.c (r1.65 -> r1.66)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/executor/nodeAppend.c.diff?r1=1.65&r2=1.66)
pgsql/src/backend/optimizer/path:
costsize.c (r1.152 -> r1.153)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/path/costsize.c.diff?r1=1.152&r2=1.153)
indxpath.c (r1.200 -> r1.201)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/path/indxpath.c.diff?r1=1.200&r2=1.201)
joinpath.c (r1.101 -> r1.102)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/path/joinpath.c.diff?r1=1.101&r2=1.102)
pgsql/src/backend/optimizer/plan:
setrefs.c (r1.119 -> r1.120)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/plan/setrefs.c.diff?r1=1.119&r2=1.120)
pgsql/src/backend/optimizer/util:
relnode.c (r1.76 -> r1.77)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/util/relnode.c.diff?r1=1.76&r2=1.77)
pgsql/src/include/optimizer:
pathnode.h (r1.65 -> r1.66)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/optimizer/pathnode.h.diff?r1=1.65&r2=1.66)

Browse pgsql-committers by date

  From Date Subject
Next Message Bruce Momjian 2006-02-05 18:19:14 pgsql: Fix typo in configuration docs.
Previous Message User T-ishii 2006-02-05 02:54:48 pgpool - pgpool: include pgpool.spec and re-release 3.0.0