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

Popular posts from this blog

c++ - Convert big endian to little endian when reading from a binary file -

C#: Application without a window or taskbar item (background app) that can still use Console.WriteLine() -

unicode - Are email addresses allowed to contain non-alphanumeric characters? -