setup.sql

application/octet-stream

Filename: setup.sql
Type: application/octet-stream
Part: 0
Message: Re: Adding REPACK [concurrently]
CREATE TABLE stress_victim (
    id SERIAL PRIMARY KEY,
    balance INT,
    payload TEXT
);

CREATE TABLE stress_shadow (
    id SERIAL PRIMARY KEY,
    balance INT,
    payload TEXT
);

INSERT INTO stress_victim (balance, payload)
SELECT
    (random()*1000)::int,
    repeat(md5(random()::text), 6)
FROM generate_series(1, 5000000);

INSERT INTO stress_shadow SELECT * FROM stress_victim;