[Bizgres-general] Multi-column index support for bitmap indexes is in CVS tip

[Luke Lonergan]

Good timing Jie - right before the Postgres anniversary conference in
Toronto!

- Luke


On 7/6/06 6:53 PM, "Jie Zhang" <jzhang at greenplum.com> wrote:

> 
> I have checked in changes to the CVS tip about multi-column index support
> for bitmap indexes. This also includes some bug-fixes for maintaining bitmap
> indexes while doing update/delete/vacuum operations.
> 
> To create a multi-column bitmap index, use the following command:
> 
> create index <index_name> on <table> using bitmap(<att1>, <att2>, ...);
> 
> This implementation will create one bitmap vector for each distinct list of
> values (v1,v2,...), one for each attribute. Therefore, queries whose query
> predicates have the form of "<att1>=<v1> and <att2>=<v2> and ..." will be
> answered more efficiently.
> 
> You are more than welcome to check this out, and let me know if you have any
> problems with this.
> 
> Thanks,
> Jie
> 
> 
> _______________________________________________
> Bizgres-general mailing list
> Bizgres-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/bizgres-general
>