Postgres Pro
Downloads
Home   >   mailing lists

Re: Any way to favor index scans, but not bitmap index scans? - Mailing list pgsql-general

From Tom Lane
Subject Re: Any way to favor index scans, but not bitmap index scans?
Date
Msg-id 17122.1216831233@sss.pgh.pa.us
Whole thread Raw
In response to Any way to favor index scans, but not bitmap index scans?  ("Francisco Reyes" <lists@stringsutils.com>)
Responses Re: Any way to favor index scans, but not bitmap index scans?
List pgsql-general
Tree view 
"Francisco Reyes" <lists@stringsutils.com> writes:
> So far in this data set almost every time bitmap scans are used the queries
> do worse, much worse. I had one extreme case where a sequential scan would
> finish in 20 minutes and the same query using bitmap scans would take over
> a day to finish.

That's fairly hard to believe.  Care to offer some details?

            regards, tom lane

pgsql-general by date:

Previous
From: Shane Ambler
Date:
Subject: Re: A couple of newbie questions ...
Next
From: Craig Ringer
Date:
Subject: Re: A couple of newbie questions ...