CREATE EXTENSION bloom;

CREATE TABLE tst (i int4, t text);

INSERT INTO tst SELECT i%10000, substr(md5(i::text), 1, 1) FROM generate_series(1,1000000) i;
CREATE INDEX bloomidx ON tst USING bloom (i, t) WITH (col1 = 13);

DELETE FROM tst WHERE i = 5;
VACUUM tst;

DELETE FROM tst WHERE i = 2;
VACUUM tst;

DELETE FROM tst WHERE i = 8;
VACUUM tst;

DELETE FROM tst WHERE t = '5';
VACUUM tst;

DELETE FROM tst WHERE t = '2';
VACUUM tst;

DELETE FROM tst WHERE t = '8';
VACUUM tst;

DROP TABLE tst;

CREATE TABLE tst (i int4, t text);

INSERT INTO tst SELECT i%1000, substr(md5(i::text), 1, 1) FROM generate_series(1,1000000) i;
CREATE INDEX bloomidx ON tst USING bloom (i, t) WITH (col1 = 13);

DELETE FROM tst WHERE i = 5;
VACUUM tst;

DELETE FROM tst WHERE i = 2;
VACUUM tst;

DELETE FROM tst WHERE i = 8;
VACUUM tst;

DROP TABLE tst;

DROP EXTENSION bloom;