setup.sql

application/octet-stream

Filename: setup.sql

Type: application/octet-stream

Part: 2

Message: Re: Adding REPACK [concurrently]

DROP TABLE IF EXISTS stress_victim;
DROP TABLE IF EXISTS stress_shadow;

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;