Re: Horribly slow hash join

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Horribly slow hash join
Дата
Msg-id 15053.1082259958@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Horribly slow hash join  (Greg Stark <gsstark@mit.edu>)
Ответы Re: Horribly slow hash join  (Greg Stark <gsstark@mit.edu>)
Список pgsql-performance
Greg Stark <gsstark@mit.edu> writes:
> Tom Lane <tgl@sss.pgh.pa.us> writes:
>> (Also, I have been harboring some notions of supporting cross-type hash
>> joins for integer types, which will not work unless small int8 values hash
>> the same as int4 etc.)

> The obvious way to modify the hash function is to xor the high 32 bits with
> the low 32 bits. That maintains the property you need

No it doesn't ...

            regards, tom lane

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

Предыдущее
От: Mark Kirkwood
Дата:
Сообщение: Re: Poor performance of group by query
Следующее
От: Dennis Bjorklund
Дата:
Сообщение: Re: Horribly slow hash join