prp_analyse.sql

application/x-sql

Filename: prp_analyse.sql

Type: application/x-sql

Part: 2

Message: pgbench - add pseudo-random permutation function

-- vals stats
SELECT * FROM perm_vals ORDER BY cnt ASC;
SELECT COUNT(*), MIN(cnt), AVG(cnt), STDDEV(cnt), MAX(cnt) FROM perm_vals;
-- perm stats
SELECT * FROM perm_count ORDER BY cnt ASC;
SELECT COUNT(*), MIN(cnt), AVG(cnt), STDDEV(cnt), MAX(cnt) FROM perm_count;