64 подписчика

-- OLTP

-- scenario1.sql

-- 5.2

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

DECLARE

test_rec record ;

current_aid bigint ;

BEGIN

-- !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

-- ТОЛЬКО ДЛЯ scale = 685

-- !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

current_aid = floor(random() * (68500000 - 1 + 1)) + 1 ;

select acc.abalance

into test_rec

from pgbench_accounts acc

where acc.aid = current_aid ;

return 0 ;

END

$$ LANGUAGE plpgsql;

Около минуты

Вчера