prp_test_2.sql

application/x-sql

Filename: prp_test_2.sql

Type: application/x-sql

Part: 4

Message: pgbench - add pseudo-random permutation function

\set seed random(1, 1000000000000000000)
\set i0 pr_perm(0, 2, :default_seed + :seed)
\set i1 pr_perm(1, 2, :default_seed + :seed)
INSERT INTO perm_count AS pc (perm)
  VALUES (:i0 + :i1*10)
  ON CONFLICT (perm) DO UPDATE SET cnt = pc.cnt+1;