-- 拡張追加
create extension bloom
-- 拡張確認
SELECT * FROM pg_available_extensions WHERE installed_version IS NOT NULL
-- bloomインデックスを追加
CREATE INDEX idx_res_match ON res_match USING bloom (factory_cd, line_cd, seq_no, lotserial, cp_cd)