prp_init.sql

application/x-sql

Filename: prp_init.sql

Type: application/x-sql

Part: 1

Message: pgbench - add pseudo-random permutation function

DROP TABLE IF EXISTS perm_count;
DROP TABLE IF EXISTS perm_vals;
CREATE UNLOGGED TABLE perm_count(perm INT PRIMARY KEY, cnt INT8 NOT NULL DEFAULT 1);
CREATE UNLOGGED TABLE perm_vals(i INT, v INT, PRIMARY KEY(i, v), cnt INT8 NOT NULL DEFAULT 1);