20201110-testcase2.pgbench

application/octet-stream

Filename: 20201110-testcase2.pgbench

Type: application/octet-stream

Part: 6

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 aid3 random_gaussian(1, 100000 * :scale, 3.2)
BEGIN;
SELECT abalance FROM pgbench_accounts WHERE aid = :aid1;
SELECT abalance FROM pgbench_accounts WHERE aid = :aid2;
SELECT abalance FROM pgbench_accounts WHERE aid = :aid3;
END;