Re: hash index improving v3

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: hash index improving v3
Дата
Msg-id 11525.1220579153@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: hash index improving v3  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: hash index improving v3  ("Alex Hunsaker" <badalex@gmail.com>)
Список pgsql-patches
I wrote:
> You have the unique-versus-not dimension,

On second thought, actually not.  What we want to look at is the penalty
for false matches due to *distinct* key values that happen to have the
same hash codes.  Your test case for all-the-same is using all the same
key values, which means it'll hit the heap a lot, but none of those will
be wasted trips.

So what we need for testing is a few different key values that hash to
the same code.  Not sure about an easy way to find such.

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: hash index improving v3
Следующее
От: "Alex Hunsaker"
Дата:
Сообщение: Re: hash index improving v3