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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Any way to favor index scans, but not bitmap index scans?
Дата
Msg-id 17122.1216831233@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Any way to favor index scans, but not bitmap index scans?  ("Francisco Reyes" <lists@stringsutils.com>)
Ответы Re: Any way to favor index scans, but not bitmap index scans?  ("Francisco Reyes" <lists@stringsutils.com>)
Список pgsql-general
"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 по дате отправления:

Предыдущее
От: Shane Ambler
Дата:
Сообщение: Re: A couple of newbie questions ...
Следующее
От: Craig Ringer
Дата:
Сообщение: Re: A couple of newbie questions ...