reload.pgb

application/octet-stream

Download

\set pubid random(1, 100000000)
\set aid random(1, 100000 * :scale)
\set bid random(1, 1 * :scale)
\set tid random(1, 10 * :scale)
\set delta random(-5000, 5000)

BEGIN;
UPDATE pgbench_accounts SET abalance = abalance + :delta WHERE aid = :aid;
SELECT abalance FROM pgbench_accounts WHERE aid = :aid;
INSERT INTO pgbench_history (tid, bid, aid, delta, mtime) VALUES (:tid, :bid, :aid, :delta, CURRENT_TIMESTAMP);
END;

begin;
SELECT pg_create_logical_replication_slot('myls:pubid', 'pgoutput', false);
select pg_reload_conf();
SELECT pg_drop_replication_slot('myls:pubid');
commit;