huge table / bitmap indexes

Поиск
Список
Период
Сортировка
Искать

huge table / bitmap indexes

От:
cure@icpnet.pl
Дата:
Hello All

 is  in  postgres  any possibility to create bitmap index ? I have big
 (~12  000  000  records)  table where one field have limited count of
 values.  Many  queries  use this field in where section. I thing that
 bitmap index will by better than BTree.
 How i can optimize select on this table ?

    Thanks - Cure
  

-- 
The poor player plays the opponent's game for him. 
 cure                          mailto:cure@icpnet.pl

Re: huge table / bitmap indexes

От:
"scott.marlowe" <scott.marlowe@ihs.com>
Дата:
On Thu, 19 Jun 2003 cure@icpnet.pl wrote:

> Hello All
> 
>  is  in  postgres  any possibility to create bitmap index ? I have big
>  (~12  000  000  records)  table where one field have limited count of
>  values.  Many  queries  use this field in where section. I thing that
>  bitmap index will by better than BTree.
>  How i can optimize select on this table ?

Might a partial index help?

create index tb_dx on tb (field) where field=1

kind of thing?

FAQ