装好bloom插件
postgres=# \dx
List of installed extensions
Name|Version|Schema|Description
bloom|1.0|public|bloom access method - signature file based index
dblink|1.2|public|connect to other PostgreSQL databases from within a database
pg_trgm|1.4|public|text similarity measurement and index searching based on trigrams
plpgsql|1.0|pg_catalog|PL/pgSQL procedural language
建表
postgres=# create table t_bloom (c1 int ,c2 int ,c3 int ,c4 int);
CREATE TABLE
建bloom索引
postgres=# create index on t_bloom using bloom (c1,c2,c3);
CREATE INDEX
查看bloom索引的使用情况
postgres=# explain select * from t_bloom where c1=1;
QUERY PLAN
Bitmap Heap Scan on t_bloom (cost=15.18…22.63 rows=9 width=16)
Recheck Cond: (c1 = 1)
-> Bitmap Index Scan on t_bloom_c1_c2_c3_idx (cost=0.00…15.18 rows=9 width=0)
Index Cond: (c1 = 1)
(4 rows)
postgres=#