prp_perf.sql

application/x-sql

Filename: prp_perf.sql

Type: application/x-sql

Part: 10

Message: pgbench - add pseudo-random permutation function

-- 4.772 / 0.210 µs
\set i random(1, 1000000000)
-- 3.949 / 0.253 µs => 0.043 µs for an assignement
-- \set j 0
-- 3.062 / 0.327 µs => 0.075 µs/call
-- \set j :i + :i
-- 3.089 / 0.324 µs => 0.071 µs/call
-- \set j hash(:i)
-- 2.115 / 0.473 µs => 0.220 µs/call
-- \set j pr_perm(:i, 1000000000)