66 подписчиков

-- scenario1.sql UPDATE

CREATE OR REPLACE FUNCTION scenario1() RETURNS integer AS $$

DECLARE

test_rec record ;

min_i bigint ;

max_i bigint ;

current_aid bigint ;

current_tid bigint ;

current_bid bigint ;

current_delta bigint ;

counter bigint;

BEGIN

current_delta = (ROUND( random ())::bigint)*10 + 1 ;

SELECT MIN(aid) INTO min_i FROM pgbench_accounts ;

SELECT MAX(aid) INTO max_i FROM pgbench_accounts ;

current_aid = floor(random() * (max_i - min_i + 1)) + min_i ;

UPDATE pgbench_accounts SET abalance = abalance + current_delta WHERE aid = current_aid ;

SELECT abalance INTO test_rec FROM pgbench_accounts WHERE aid = current_aid ;

SELECT MIN(tid) INTO min_i FROM pgbench_tellers ;

SELECT MAX(tid) INTO max_i FROM pgbench_tellers ;

current_tid = floor(random() * (max_i - min_i + 1)) + min_i ;

UPDATE pgbench_tellers SET tbalance = tbalance + current_delta WHERE tid = current_tid ;

SELECT MIN(bid) INTO min_i FROM pgbench_branches ;

SELECT MAX(bid) INTO max_i FROM pgbench_branches ;

current_bid = floor(random() * (max_i - min_i + 1)) + min_i ;

UPDATE pgbench_branches SET bbalance = bbalance + current_delta WHERE bid = current_bid ;

return 0 ;

END

$$ LANGUAGE plpgsql;

Около минуты

16 марта