From: | Michael Glaesemann <grzm(at)seespotcode(dot)net> |
---|---|
To: | cluster <skrald(at)amossen(dot)dk> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Bitmap index? |
Date: | 2007-07-01 00:31:24 |
Message-ID: | EEA9158A-2903-4052-B874-22DFAB278A37@seespotcode.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Jun 30, 2007, at 18:23 , cluster wrote:
> In postgresql 8.2 I need a bitmap index for a certain column, but
> how do I create it?
> (No, a btree is not sufficient. :-) )
Where do you see that PostgreSQL has bitmap indexes?
http://www.postgresql.org/docs/8.2/interactive/indexes-types.html
PostgreSQL can combine multiple indexes and use a bitmap scan during
query execution, but this is not an on-disk bitmap index.
http://www.postgresql.org/docs/8.2/interactive/indexes-bitmap-scans.html
Perhaps if you give more information concerning your situation and
why you believe B-tree indexes are not sufficient, others on the list
might be able to provide suggestions.
Michael Glaesemann
grzm seespotcode net
From | Date | Subject | |
---|---|---|---|
Next Message | Martijn van Oosterhout | 2007-07-01 10:55:38 | Re: Looking for help regarding getting the latest inserted sequence value. |
Previous Message | cluster | 2007-06-30 23:23:57 | Bitmap index? |