pgbench - add pseudo-random permutation function

Поиск
Список
Период
Сортировка
От Fabien COELHO
Тема pgbench - add pseudo-random permutation function
Дата
Msg-id alpine.DEB.2.21.1807280944370.5142@lancre
обсуждение исходный текст
Ответы Re: pgbench - add pseudo-random permutation function
Список pgsql-hackers
Hello,

This patch adds a pseudo-random permutation function to pgbench. It allows 
to mix non uniform random keys to avoid trivial correlations between 
neighboring values, hence between pages.

The function is a simplistic form of encryption adapted to any size, using 
a few iterations of scramble and scatter phases. The result is not 
cryptographically convincing, nor even statistically, but it is quite 
inexpensive and achieves the desired result. A computation costs 0.22 µs 
per call on my laptop, about three times the cost of a simple function.

Alternative designs, such as iterating over an actual encryption function 
or using some sbox, would lead to much more costly solutions and complex 
code.

I also join a few scripts I used for testing.

-- 
Fabien.
Вложения

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

Предыдущее
От: Fabien COELHO
Дата:
Сообщение: Re: Removing useless \. at the end of copy in pgbench
Следующее
От: Ioseph Kim
Дата:
Сообщение: modify: request for new parameter for disable promote (slave onlymode)