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

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Bruno Lavoie <bruno(dot)lavoie(at)gmail(dot)com>
Cc: PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Re: Indexing columns with low cardinality: persistent bitmap indexes?
Date: 2009-01-12 20:40:38
Message-ID: 20090112204038.GK4919@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Reg Me Please 2009-01-12 21:16:41 Re: Indexing columns with low cardinality: persistent bitmap indexes?
Previous Message Bruno Lavoie 2009-01-12 20:38:02 Indexing columns with low cardinality: persistent bitmap indexes?