pgsql: Tweak hash join code to use an additional heuristic for deciding

Поиск
Список
Период
Сортировка
От tgl@postgresql.org (Tom Lane)
Тема pgsql: Tweak hash join code to use an additional heuristic for deciding
Дата
Msg-id 20051128234603.A90B79DCC43@postgresql.org
обсуждение исходный текст
Список 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)

В списке pgsql-committers по дате отправления:

Предыдущее
От: momjian@postgresql.org (Bruce Momjian)
Дата:
Сообщение: pgsql: Improve documentation for COALESCE and NULLIF.
Следующее
От: tgl@postgresql.org (Tom Lane)
Дата:
Сообщение: pgsql: Tweak hash join code to use an additional heuristic for deciding