Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux