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

From Tom Lane
Subject Re: BUG #2075: Strange choice of bitmap-index-scan
Date
Msg-id 29048.1133370711@sss.pgh.pa.us
Whole thread Raw
In response to BUG #2075: Strange choice of bitmap-index-scan  ("Arjen" <acmmailing@tweakers.net>)
Responses Re: BUG #2075: Strange choice of bitmap-index-scan  (Arjen van der Meijden <acmmailing@tweakers.net>)
List pgsql-bugs
"Arjen" <acmmailing@tweakers.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

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #2080: Partitioning does not work with PREPARE
Next
From: Arjen van der Meijden
Date:
Subject: Re: BUG #2075: Strange choice of bitmap-index-scan