alternative to bitmap index in postgresql -
i have table hundreds of millions rows schema below.
tabe aa { id integer primay key, prop0 boolean not null, prop1 boolean not null, prop2 smallint not null, ... }
the each "property" field (prop0, prop1, ...) has small number of distinct values. , query find "id" given conditions of properties fields. think bitmap index best query. postgresql seems not support bitmap index.
i tried b-tree index on each field these indexes not used according query explain.
is there alternative way this?
(i'm using postgresql 9)
your real problem bad schema design, not index. properties should placed in different table , current table should link table using many many relation.
the bit datatype might of use, check manual.
Comments
Post a Comment