Benjamin Arai <benjamin(at)araisoft(dot)com> writes:
> To follow up on my own email, by disabling BitmapScan in my
> postgresql.conf the performance seems to be better. Is something
> wrong with the query analyzer?
I just rewrote choose_bitmap_and() to fix some issues that might be
related to this; please try your query with 8.2.4 or 8.1.9 as the
case may be (and next time, mention what version you're using
right off the bat).
regards, tom lane