scheme.sql

application/sql

Download

DROP TABLE IF EXISTS something_is_wrong_here;

CREATE TABLE something_is_wrong_here (id bigserial PRIMARY KEY, value numeric(15,4) DEFAULT 0 NOT NULL);

INSERT INTO something_is_wrong_here (value) (SELECT 10000 from generate_series(0, 100));

SELECT txid_current() \gset

SELECT :txid_current + 1 as txid \gset

ALTER SYSTEM SET vacuum_defer_cleanup_age to :txid;SELECT pg_reload_conf();