Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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)

pgsql-committers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group