pgsql: Buy back some of the cycles spent in more-expensive hash

Поиск
Список
Период
Сортировка
От tgl@postgresql.org (Tom Lane)
Тема pgsql: Buy back some of the cycles spent in more-expensive hash
Дата
Msg-id 20070601173844.4D7119FC4C0@postgresql.org
обсуждение исходный текст
Список pgsql-committers
Log Message:
-----------
Buy back some of the cycles spent in more-expensive hash functions by
selecting power-of-2, rather than prime, numbers of buckets in hash joins.
If the hash functions are doing their jobs properly by making all hash bits
equally random, this is good enough, and it saves expensive integer division
and modulus operations.

Modified Files:
--------------
    pgsql/src/backend/executor:
        nodeHash.c (r1.111 -> r1.112)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/executor/nodeHash.c.diff?r1=1.111&r2=1.112)
    pgsql/src/include/executor:
        hashjoin.h (r1.44 -> r1.45)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/executor/hashjoin.h.diff?r1=1.44&r2=1.45)

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

Предыдущее
От: tgl@postgresql.org (Tom Lane)
Дата:
Сообщение: pgsql: Fix performance problems in multi-batch hash joins by ensuring
Следующее
От: momjian@postgresql.org (Bruce Momjian)
Дата:
Сообщение: pgsql: Update wording: o Research self-referential UPDATEs that