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

pgsql: Improve hash join to discard input tuples immediately if they

From: tgl(at)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Improve hash join to discard input tuples immediately if they
Date: 2007-01-28 23:21:26
Message-ID: 20070128232126.84CDC9FB319@postgresql.org (view raw or flat)
Thread:
Lists: pgsql-committers
Log Message:
-----------
Improve hash join to discard input tuples immediately if they can't
match because they contain a null join key (and the join operator is
known strict).  Improves performance significantly when the inner
relation contains a lot of nulls, as per bug #2930.

Modified Files:
--------------
    pgsql/src/backend/executor:
        nodeHash.c (r1.108 -> r1.109)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/executor/nodeHash.c.diff?r1=1.108&r2=1.109)
        nodeHashjoin.c (r1.86 -> r1.87)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/executor/nodeHashjoin.c.diff?r1=1.86&r2=1.87)
    pgsql/src/include/executor:
        hashjoin.h (r1.42 -> r1.43)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/executor/hashjoin.h.diff?r1=1.42&r2=1.43)
        nodeHash.h (r1.42 -> r1.43)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/executor/nodeHash.h.diff?r1=1.42&r2=1.43)

pgsql-committers by date

Next:From: User OkbobDate: 2007-01-29 07:58:16
Subject: plpsm - plpgpsm: merge patch: Make some small improvements in the
Previous:From: Tom LaneDate: 2007-01-28 21:17:32
Subject: pgsql: Remove unnecessary checkpoint from PL regression tests.

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