Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group