20210103-testcase2.pgbench

application/octet-stream

Filename: 20210103-testcase2.pgbench

Type: application/octet-stream

Part: 7

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

\set aid2 random_gaussian(1, 100000 * :scale, 3.0)
SELECT abalance FROM pgbench_accounts WHERE aid = :aid2;
INSERT INTO pgbench_accounts
SELECT aid+1, bid, abalance, filler, now() FROM pgbench_accounts ORDER BY aid DESC LIMIT 2
ON CONFLICT DO NOTHING;
DELETE FROM pgbench_accounts WHERE aid IN
  (SELECT aid FROM pgbench_accounts ORDER BY aid LIMIT 2);