Re: General purpose hashing func in pgbench

Поиск
Список
Период
Сортировка
От Fabien COELHO
Тема Re: General purpose hashing func in pgbench
Дата
Msg-id alpine.DEB.2.20.1712251506160.22976@lancre
обсуждение исходный текст
Ответ на Re: General purpose hashing func in pgbench  (Ildar Musin <i.musin@postgrespro.ru>)
Ответы Re: General purpose hashing func in pgbench  (Ildar Musin <i.musin@postgrespro.ru>)
Re: General purpose hashing func in pgbench  (Stephen Frost <sfrost@snowman.net>)
Список pgsql-hackers
Hello,

>> I noticed from the source of all human knowledege (aka Wikipedia:-)
>> that there seems to be a murmur3 successor. Have you considered it?
>> One good reason to skip it would be that the implementation is long
>> and complex. I'm not sure about a 8-byte input simplified version.
> Murmur2 naturally supports 8-byte data. Murmur3 has 32- and 128-bit
> versions.

Ok.

So it would make sense to keep the 64 bit murmur2 version.

Pgbench ints are 64 bits, seems logical to keep them that way, so 32 bits 
versions do not look too interesting.

>> Just a question: Have you looked at SipHash24?
>
> Not yet. As I can understand from the wiki its main feature is to
> prevent attacks with crafted input data. How can it be useful in
> benchmarking?

No and yes:-)

The attack prevention is pretty useless in the context.

However, the key can be used if controlled so that different values do not 
have the same randomization in different part of the script, so as to 
avoid using the same patterns for different things if not desirable.

For the pgbench pseudo-random permutation I'm looking at, the key can be 
specified to control whether the same pattern or not should be used.

-- 
Fabien.


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

Предыдущее
От: Ildar Musin
Дата:
Сообщение: Re: General purpose hashing func in pgbench
Следующее
От: Aleksandr Parfenov
Дата:
Сообщение: Re: [HACKERS] Flexible configuration for full-text search