Re: BUG #2075: Strange choice of bitmap-index-scan - Mailing list pgsql-bugs

"Arjen" <acmmailing@tweakers.net> writes:
>    ->  BitmapAnd  (cost=5.62..5.62 rows=1 width=0)
>          ->  Bitmap Index Scan on pwprodukten_cat2_popuindex
> (cost=0.00..2.50 rows=144 width=0)
>                Index Cond: (cat2 = 51)
>          ->  Bitmap Index Scan on pwprodukten_cat2_zichtbaar
> (cost=0.00..2.86 rows=144 width=0)
>                Index Cond: ((cat2 = 51) AND (zichtbaar = true))

Hmmm ... I can reproduce that if *all* the rows in the table have
zichtbaar = true (or at least the ANALYZE stats say so) ... is that
the case in your data?

            regards, tom lane