PGBench Transaction Typebegin; update accounts set abalance = abalance + :delta where aid = :aid; select abalance from accounts where aid = :aid; update tellers set tbalance = tbalance + :delta where tid = :tid; update branches set bbalance = bbalance + :delta where bid = :bid; insert into history(tid,bid,aid,delta) values(:tid,:bid,:aid,:delta); end;
|