Re: Hash joins vs small-integer join values

Поиск
Список
Период
Сортировка
От Gregory Stark
Тема Re: Hash joins vs small-integer join values
Дата
Msg-id 87zm3kxrg0.fsf@oxford.xeocode.com
обсуждение исходный текст
Ответ на Hash joins vs small-integer join values  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Hash joins vs small-integer join values  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
"Tom Lane" <tgl@sss.pgh.pa.us> writes:

> The best idea I can come up with for the back branches is
> to make ExecHashGetBucketAndBatch do hash_any internally, say

hashany of a 4-byte value degenerates to pretty much just a call to mix().
Perhaps we should just expose a hash12() that takes three integers and calls
mix() on them like hash_any does.

The reason I'm thinking that is that we'll want to do the same thing for
bigint, float4, float8, etc.

And that fix you committed a while back to improve the catcache hash function
made a huge difference. Now I'm wondering if it shouldn't just be invoking
hash_any() or mix() too.

--  Gregory Stark EnterpriseDB          http://www.enterprisedb.com



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

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: Hash joins vs small-integer join values
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Hash joins vs small-integer join values