20201110-testcase1.pgbench

application/octet-stream

Filename: 20201110-testcase1.pgbench

Type: application/octet-stream

Part: 5

Message: Re: Deleting older versions in unique indexes to avoid page splits

\set aid1 random_gaussian(1, 100000 * :scale, 2.0)
\set aid2 random_gaussian(1, 100000 * :scale, 2.5)
\set delta random(-5000, 5000)
BEGIN;
UPDATE pgbench_accounts SET abalance = abalance + :delta WHERE aid = :aid1;
SELECT abalance FROM pgbench_accounts WHERE aid = :aid2;
END;