skewed-select.sql

text/x-sql

Filename: skewed-select.sql

Type: text/x-sql

Part: 1

Message: Re: pgbench: new feature allowing to launch shell commands

\set naccounts 100000 * :scale
-- This doesn't work:
--\setshell aid skewed-acct.pl :naccounts
-- Have to hard-code the value instead:
\setshell :aid skewed-acct.pl 1000000
SELECT abalance FROM pgbench_accounts WHERE aid = :aid;
-- This doesn't work as expected either
-- \shell echo :aid