Quick Links

Indexing columns with low cardinality: persistent bitmap indexes?

From:	Bruno Lavoie <bruno(dot)lavoie(at)gmail(dot)com>
To:	PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject:	Indexing columns with low cardinality: persistent bitmap indexes?
Date:	2009-01-12 20:38:02
Message-ID:	496BAA2A.10505@gmail.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

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

Responses

Re: Indexing columns with low cardinality: persistent bitmap indexes? at 2009-01-12 20:40:38 from Alvaro Herrera
Re: Indexing columns with low cardinality: persistent bitmap indexes? at 2009-01-12 21:16:41 from Reg Me Please
Re: Indexing columns with low cardinality: persistent bitmap indexes? at 2009-01-12 21:29:01 from Scott Marlowe

Browse pgsql-general by date

	From	Date	Subject
Next Message	Alvaro Herrera	2009-01-12 20:40:38	Re: Indexing columns with low cardinality: persistent bitmap indexes?
Previous Message	Joshua D. Drake	2009-01-12 20:23:45	PgUS 2008 end of year summary