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

From: Reg Me Please <regmeplease(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Cc: Bruno Lavoie <bruno(dot)lavoie(at)gmail(dot)com>
Subject: Re: Indexing columns with low cardinality: persistent bitmap indexes?
Date: 2009-01-12 21:16:41
Message-ID: 200901122216.41306.regmeplease@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jaime Casanova 2009-01-12 21:20:40 Re: Indexing columns with low cardinality: persistent bitmap indexes?
Previous Message Alvaro Herrera 2009-01-12 20:40:38 Re: Indexing columns with low cardinality: persistent bitmap indexes?