Re: BUG #2075: Strange choice of bitmap-index-scan

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Arjen" <acmmailing(at)tweakers(dot)net>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2075: Strange choice of bitmap-index-scan
Date: 2005-11-29 16:31:51
Message-ID: 7826.1133281911@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Arjen" <acmmailing(at)tweakers(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2005-11-29 16:40:41 Re: pg_dump: schema with OID 559701082 does not exist
Previous Message Bruce Momjian 2005-11-29 16:04:21 Re: BUG #2073: Can't drop sequence when created via SERIAL column