Re: Any way to favor index scans, but not bitmap index scans?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: lists(at)stringsutils(dot)com
Cc: " Pgsql General list " <pgsql-general(at)postgresql(dot)org>
Subject: Re: Any way to favor index scans, but not bitmap index scans?
Date: 2008-07-23 16:40:33
Message-ID: 17122.1216831233@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Francisco Reyes" <lists(at)stringsutils(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Craig Ringer 2008-07-23 16:46:18 Re: A couple of newbie questions ...
Previous Message Sushant Sinha 2008-07-23 16:17:26 Re: [GENERAL] Fragments in tsearch2 headline