Benjamin Arai <benjamin@xxxxxxxxxxxx> 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