pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedBITMAP INDEXES...
3+ messages / 3 participants
[nested] [flat]
* BITMAP INDEXES...
@ 2002-08-22 08:22 Rajesh Kumar Mallah. <mallah@trade-india.com>
2002-08-22 14:30 ` Re: BITMAP INDEXES... Bruce Momjian <pgman@candle.pha.pa.us>
0 siblings, 1 reply; 3+ messages in thread
From: Rajesh Kumar Mallah. @ 2002-08-22 08:22 UTC (permalink / raw)
To: pgsql-sql
Hi,
I have learnt from certain texts that bitmap indexes are very useful for
large DSS (decesion support systems).
bitmap indexes are currently not available in postgresql.
My question is in what way is a normal btree index in pgsql
inferior to bitmap indexes (found in oracle for example).
is it just in terms of space requirements for performance too?
regds
mallah.
--
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L) ,9811255597 (M)
Visit http://www.trade-india.com ,
India's Leading B2B eMarketplace.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: BITMAP INDEXES...
2002-08-22 08:22 BITMAP INDEXES... Rajesh Kumar Mallah. <mallah@trade-india.com>
@ 2002-08-22 14:30 ` Bruce Momjian <pgman@candle.pha.pa.us>
2002-08-22 16:26 ` Re: BITMAP INDEXES... imtiaz sm <imtiaz_sm@yahoo.com>
0 siblings, 1 reply; 3+ messages in thread
From: Bruce Momjian @ 2002-08-22 14:30 UTC (permalink / raw)
To: Rajesh Kumar Mallah. <mallah@trade-india.com>; +Cc: pgsql-sql
See the email about bitmapped indexes linked to from the TODO list item
on bitmaps. Bitmap indexes allow arbitrary indexes to be combined into
a single index. Btree indexes can not be combined.
---------------------------------------------------------------------------
Rajesh Kumar Mallah. wrote:
> Hi,
>
> I have learnt from certain texts that bitmap indexes are very useful for
> large DSS (decesion support systems).
>
> bitmap indexes are currently not available in postgresql.
>
> My question is in what way is a normal btree index in pgsql
> inferior to bitmap indexes (found in oracle for example).
>
> is it just in terms of space requirements for performance too?
>
>
> regds
> mallah.
>
>
> --
> Rajesh Kumar Mallah,
> Project Manager (Development)
> Infocom Network Limited, New Delhi
> phone: +91(11)6152172 (221) (L) ,9811255597 (M)
>
> Visit http://www.trade-india.com ,
> India's Leading B2B eMarketplace.
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: BITMAP INDEXES...
2002-08-22 08:22 BITMAP INDEXES... Rajesh Kumar Mallah. <mallah@trade-india.com>
2002-08-22 14:30 ` Re: BITMAP INDEXES... Bruce Momjian <pgman@candle.pha.pa.us>
@ 2002-08-22 16:26 ` imtiaz sm <imtiaz_sm@yahoo.com>
0 siblings, 0 replies; 3+ messages in thread
From: imtiaz sm @ 2002-08-22 16:26 UTC (permalink / raw)
To: Bruce Momjian <pgman@candle.pha.pa.us>; Rajesh Kumar Mallah. <mallah@trade-india.com>; +Cc: pgsql-sql
Bitmapped indexes are good for weakly constrained queries. Else B+tree indexes are better any day.
Also I guess bitmapped indexes work better when there is an OR predicate on different columns in a query.
Bruce Momjian
wrote:
See the email about bitmapped indexes linked to from the TODO list item
on bitmaps. Bitmap indexes allow arbitrary indexes to be combined into
a single index. Btree indexes can not be combined.
---------------------------------------------------------------------------
Rajesh Kumar Mallah. wrote:
> Hi,
>
> I have learnt from certain texts that bitmap indexes are very useful for
> large DSS (decesion support systems).
>
> bitmap indexes are currently not available in postgresql.
>
> My question is in what way is a normal btree index in pgsql
> inferior to bitmap indexes (found in oracle for example).
>
> is it just in terms of space requirements for performance too?
>
>
> regds
> mallah.
>
>
> --
> Rajesh Kumar Mallah,
> Project Manager (Development)
> Infocom Network Limited, New Delhi
> phone: +91(11)6152172 (221) (L) ,9811255597 (M)
>
> Visit http://www.trade-india.com ,
> India's Leading B2B eMarketplace.
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
---------------------------------
Do You Yahoo!?
HotJobs, a Yahoo! service - Search Thousands of New Jobs
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2002-08-22 16:26 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-08-22 08:22 BITMAP INDEXES... Rajesh Kumar Mallah. <mallah@trade-india.com>
2002-08-22 14:30 ` Bruce Momjian <pgman@candle.pha.pa.us>
2002-08-22 16:26 ` imtiaz sm <imtiaz_sm@yahoo.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox