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

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: Any way to favor index scans, but not bitmap index scans?
Дата
Msg-id dcc563d10807231123v5e97c955nbf61c928d85897c5@mail.gmail.com
обсуждение исходный текст
Ответ на Re: 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
On Wed, Jul 23, 2008 at 11:43 AM, Francisco Reyes
<lists@stringsutils.com> wrote:
> On 12:40 pm 07/23/08 Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> That's fairly hard to believe.  Care to offer some details?
>
>
> I will dig that actual project and run explain analyze. Will likely not
> have it till middle of next week though because of a monthly process
> starting out Friday.
>
> However, I do have a current example where bitmap index scan was 3 times
> worse. On the extremely bad case the data set was 5 times larger than the
> sample below (1+ billion vs 215 million).

What is your work_mem set to?

В списке pgsql-general по дате отправления:

Предыдущее
От: "Douglas McNaught"
Дата:
Сообщение: Re: mac install question
Следующее
От: dpage@pgadmin.org
Дата:
Сообщение: Re: mac install question