Re: Apparently useless bitmap scans - Mailing list pgsql-performance

From Tom Lane
Subject Re: Apparently useless bitmap scans
Date
Msg-id 26773.1178722148@sss.pgh.pa.us
Whole thread Raw
In response to Apparently useless bitmap scans  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-performance
Peter Eisentraut <peter_e@gmx.net> 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

pgsql-performance by date:

Previous
From: Gregory Stark
Date:
Subject: Re: Nested loops overpriced
Next
From: "Daniel Cristian Cruz"
Date:
Subject: Re: Nested loops overpriced