64 подписчика
-- scenario2.sql
-- INSERT
-- 5.2
CREATE OR REPLACE FUNCTION scenario2() RETURNS integer AS $$
BEGIN
---------------------------------------------------
--СЦЕНАРИЙ 3 - INSERT ONLY
-- !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
-- ТОЛЬКО ДЛЯ scale = 685
-- !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
INSERT INTO pgbench_history (
tid,
bid,
aid,
delta,
mtime )
VALUES (
floor(random() * (6850 - 1 + 1)) + 1 ,
floor(random() * (685 - 1 + 1)) + 1 ,
floor(random() * (68500000 - 1 + 1)) + 1 ,
random() * 1000.0 ,
CURRENT_TIMESTAMP )
ON CONFLICT DO NOTHING ;
--ССЦЕНАРИЙ 3 - INSERT ONLY
---------------------------------------------------
return 0 ;
END
$$ LANGUAGE plpgsql;
Около минуты
Вчера