Re: 7.2 items

mlw <markw@mohawksoft.com>

From: mlw <markw@mohawksoft.com>
To: Tom Ivar Helbekkmo <tih@kpnQwest.no>
Cc: Bruce Momjian <pgman@candle.pha.pa.us>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2001-06-07T11:36:41Z
Lists: pgsql-hackers
Tom Ivar Helbekkmo wrote:
> 
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> 
> > Here is a small list of big TODO items.  I was wondering which ones
> > people were thinking about for 7.2?
> 
> A friend of mine wants to use PostgreSQL instead of Oracle for a large
> application, but has run into a snag when speed comparisons looked
> good until the Oracle folks added a couple of BITMAP indexes.  I can't
> recall seeing any discussion about that here -- are there any plans?

I have tried to bring this up in several different forms, and hardly ever get a
nibble.

Bitmap indexes are great for text searching. Perhaps you can use
"fulltextindex" in the contrib directory. It isn't as fast as a bitmap index,
and the syntax would be different, but it would be perform better.