Skip to content

Instantly share code, notes, and snippets.

View blavoie's full-sized avatar

Bruno Lavoie blavoie

View GitHub Profile
DROP TABLE IF EXISTS pgbench_generic_log;
CREATE TABLE pgbench_generic_log (
mtime timestamptz not null default now(),
action char not null check (action in ('I', 'U', 'D')),
username text not null,
table_name text not null,
row_data jsonb not null
);
CREATE INDEX ON pgbench_generic_log USING brin (mtime);