123456789101112131415161718192021222324252627282930313233343536373839 |
- \set aid random(1, 100000)
- \set bid random(1, 100000)
- \set tid random(1, 100000)
- \set delta random(-5000,5000)
- \set shard random(0, 2)
- SET SHARD TO :shard;
- SET SERVER ROLE TO 'auto';
- BEGIN;
- UPDATE pgbench_accounts SET abalance = abalance + :delta WHERE aid = :aid;
- SELECT abalance FROM pgbench_accounts WHERE aid = :aid;
- UPDATE pgbench_tellers SET tbalance = tbalance + :delta WHERE tid = :tid;
- UPDATE pgbench_branches SET bbalance = bbalance + :delta WHERE bid = :bid;
- INSERT INTO pgbench_history (tid, bid, aid, delta, mtime) VALUES (:tid, :bid, :aid, :delta, CURRENT_TIMESTAMP);
- END;
- SET SHARDING KEY TO :aid;
- SELECT abalance FROM pgbench_accounts WHERE aid = :aid;
- SET SERVER ROLE TO 'replica';
- SELECT abalance FROM pgbench_accounts WHERE aid = :aid;
|