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-30 17:11:51
Message-ID: 29048.1133370711@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
"Arjen" <acmmailing(at)tweakers(dot)net> writes:
> So, it uses the correct index, but somehow decides to also use the other
> cat2_... index, which it doesn't need of course.

I've tweaked the heuristics in choose_bitmap_and to (hopefully) work a
bit better in scenarios like this.  Thanks for the example.

			regards, tom lane

In response to

Responses

pgsql-bugs by date

Next:From: Janko RichterDate: 2005-11-30 17:23:45
Subject: BUG #2080: Partitioning does not work with PREPARE
Previous:From: Tom LaneDate: 2005-11-30 15:04:36
Subject: Re: pg_dump: schema with OID 559701082 does not exist

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