prp_test_6.sql

application/x-sql

Filename: prp_test_6.sql

Type: application/x-sql

Part: 8

Message: pgbench - add pseudo-random permutation function

\set seed random(1, 1000000000000)
\set n 6
\set i0 pr_perm(0, :n, :seed)
\set i1 pr_perm(1, :n, :seed)
\set i2 pr_perm(2, :n, :seed)
\set i3 pr_perm(3, :n, :seed)
\set i4 pr_perm(4, :n, :seed)
\set i5 pr_perm(5, :n, :seed)
INSERT INTO perm_count AS pc (perm)
  VALUES (:i0 + :i1*10 + :i2*100 + :i3*1000 + :i4*10000 + :i5*100000)
  ON CONFLICT (perm) DO UPDATE SET cnt = pc.cnt+1;