Re: Indexing columns with low cardinality: persistent bitmap indexes?

Поиск
Список
Период
Сортировка
Искать
От
Reg Me Please
Тема
Re: Indexing columns with low cardinality: persistent bitmap indexes?
Дата
Msg-id
200901122216.41306.regmeplease@gmail.com
Ответ на
Indexing columns with low cardinality: persistent bitmap indexes? (Bruno Lavoie)
Список
Дерево обсуждения
Indexing columns with low cardinality: persistent bitmap indexes? Bruno Lavoie <bruno.lavoie@gmail.com>
Re: Indexing columns with low cardinality: persistent bitmap indexes? Alvaro Herrera <alvherre@commandprompt.com>
Re: Indexing columns with low cardinality: persistentbitmap indexes? "Dann Corbit" <DCorbit@connx.com>
Re: Indexing columns with low cardinality: persistent bitmap indexes? Reg Me Please <regmeplease@gmail.com>
Re: Indexing columns with low cardinality: persistent bitmap indexes? "Jaime Casanova" <jcasanov@systemguards.com.ec>
Re: Indexing columns with low cardinality: persistent bitmap indexes? Martin Gainty <mgainty@hotmail.com>
Re: Indexing columns with low cardinality: persistent bitmap indexes? "Scott Marlowe" <scott.marlowe@gmail.com> 
On Monday 12 January 2009 21:38:02 Bruno Lavoie wrote:
> Hello,
>
> I have a column with a small number of distinct values, indexing this
> one with a standard BTree is useless. How do I  can index this column
> efficiently? I searched and it seems that pg doesn't support the
> creation of persistent bitmap indexes... Is that feature planned in next
> releases of pg?
>
> Thanks
> Bruno Lavoie

I would try partial indexes, as many as the distinct values.
I'm not sure this would help, though.

-- 
Fahrbahn ist ein graues Band
weisse Streifen, grüner Rand
В списке pgsql-general по дате отправления
Предыдущее
От: Alvaro Herrera
Дата:
Следующее
От: Jaime Casanova
Дата:
FAQ