From: | tgl(at)postgresql(dot)org (Tom Lane) |
---|---|
To: | pgsql-committers(at)postgresql(dot)org |
Subject: | pgsql: Tweak hash join code to use an additional heuristic for deciding |
Date: | 2005-11-28 23:46:03 |
Message-ID: | 20051128234603.A90B79DCC43@postgresql.org |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers |
Log Message:
-----------
Tweak hash join code to use an additional heuristic for deciding whether
it's worth probing the outer relation for emptiness before building the
hash table. To wit, if we're rescanning a join previously performed,
remember whether we found it nonempty the previous time, and don't bother
with the probe if it was nonempty. This buys back the performance lost
in examples like Mario Weilguni's.
Modified Files:
--------------
pgsql/src/backend/executor:
nodeHashjoin.c (r1.78 -> r1.79)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/executor/nodeHashjoin.c.diff?r1=1.78&r2=1.79)
pgsql/src/include/nodes:
execnodes.h (r1.144 -> r1.145)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/nodes/execnodes.h.diff?r1=1.144&r2=1.145)
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2005-11-28 23:46:25 | pgsql: Tweak hash join code to use an additional heuristic for deciding |
Previous Message | Bruce Momjian | 2005-11-28 23:19:03 | pgsql: Improve documentation for COALESCE and NULLIF. |