Peter Eisentraut <peter_e@xxxxxxx> writes: > I'm wondering what it wants to achieve with these three index scans: See if you still get that with 8.2.4. choose_bitmap_and was fairly far out in left field before that :-( ... particularly for cases with partially redundant indexes available. regards, tom lane