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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-bugs by date

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