diff options
author | Dean Rasheed <dean.a.rasheed@gmail.com> | 2021-04-06 11:50:42 +0100 |
---|---|---|
committer | Dean Rasheed <dean.a.rasheed@gmail.com> | 2021-04-06 11:50:42 +0100 |
commit | 6b258e3d688db14aadb58dde2a72939362310684 (patch) | |
tree | b1f740242a8998a1992065f603953e848680d89b /src/backend/parser/parse_utilcmd.c | |
parent | a8af856d3257138590788e40eb84049def147acf (diff) | |
download | postgresql-6b258e3d688db14aadb58dde2a72939362310684.tar.gz postgresql-6b258e3d688db14aadb58dde2a72939362310684.zip |
pgbench: Function to generate random permutations.
This adds a new function, permute(), that generates pseudorandom
permutations of arbitrary sizes. This can be used to randomly shuffle
a set of values to remove unwanted correlations. For example,
permuting the output from a non-uniform random distribution so that
all the most common values aren't collocated, allowing more realistic
tests to be performed.
Formerly, hash() was recommended for this purpose, but that suffers
from collisions that might alter the distribution, so recommend
permute() for this purpose instead.
Fabien Coelho and Hironobu Suzuki, with additional hacking be me.
Reviewed by Thomas Munro, Alvaro Herrera and Muhammad Usama.
Discussion: https://postgr.es/m/alpine.DEB.2.21.1807280944370.5142@lancre
Diffstat (limited to 'src/backend/parser/parse_utilcmd.c')
0 files changed, 0 insertions, 0 deletions