zero.sql

application/sql

Download

--DROP INDEX IF EXISTS idx_id;
--DROP INDEX IF EXISTS idx_val;
--DROP TABLE IF EXISTS test;

CREATE TABLE test AS SELECT generate_series(1, 1000000) AS id, 0 AS val;
CREATE INDEX IF NOT EXISTS idx_id ON test USING hash (id);
CREATE INDEX IF NOT EXISTS idx_val ON test USING hash (val);

ANALYZE;