| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | User Okbob | 2007-01-29 07:58:16 | plpsm - plpgpsm: merge patch: Make some small improvements in the |
| Previous Message | Tom Lane | 2007-01-28 21:17:32 | pgsql: Remove unnecessary checkpoint from PL regression tests. |