Re: Indexing columns with low cardinality: persistent bitmap indexes? - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Indexing columns with low cardinality: persistent bitmap indexes?
Date
Msg-id 20090112204038.GK4919@alvh.no-ip.org
Whole thread Raw
In response to Indexing columns with low cardinality: persistent bitmap indexes?  (Bruno Lavoie <bruno.lavoie@gmail.com>)
Responses Re: Indexing columns with low cardinality: persistentbitmap indexes?
List pgsql-general
Bruno Lavoie escribió:
> 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...

It doesn't.

> Is that feature planned in next  releases of pg?

There are some efforts to get it done, but don't hold your breath (it
won't be in 8.4 either, as it has major problems currently.)

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-general by date:

Previous
From: Bruno Lavoie
Date:
Subject: Indexing columns with low cardinality: persistent bitmap indexes?
Next
From: Reg Me Please
Date:
Subject: Re: Indexing columns with low cardinality: persistent bitmap indexes?