DROP TABLE IF EXISTS sample;
CREATE TABLE sample (
 i INTEGER,
 f FLOAT
);
INSERT INTO sample SELECT 0, random() FROM generate_series(1, 10000000);
CREATE INDEX ON sample(f);
UPDATE sample SET i=1 WHERE f<0.05;
VACUUM ANALYZE;
