DROP TABLE IF EXISTS kv; CREATE TABLE kv( id serial primary key, key text NOT NULL UNIQUE, data text NOT NULL ); INSERT INTO kv(key, data) SELECT 'key-'||g.i::text, 'abcdefg' FROM generate_series(1, 100) g(i); VACUUM (ANALYZE, VERBOSE, FREEZE) kv; VACUUM (ANALYZE, VERBOSE) kv;