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.