bloat_bench

init.sql

CREATE TABLE test (
    id integer primary key,
    value1 float8 not null,
    value2 float8 not null,
    value3 float8 not null,
    value4 float8 not null,
    ts timestamp not null
);

CREATE INDEX test_value1_idx ON test (value1);
CREATE INDEX test_value2_idx ON test (value2);
CREATE INDEX test_value3_idx ON test (value3);
CREATE INDEX test_value4_idx ON test (value4);
CREATE INDEX test_ts_idx ON test (ts);

script.sql

\set id random(1, 10000000)
INSERT INTO test VALUES(:id, random(), random(), random(), random(), now() - random() * random() * 1800 * interval '1 second')
ON CONFLICT (id) DO UPDATE SET ts = now();