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?