Re: bitmap heap scanning

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: bitmap heap scanning
Дата
Msg-id dcc563d10803241916lcf3b446gfab42584df3b5525@mail.gmail.com
обсуждение исходный текст
Ответ на bitmap heap scanning  ("petchimuthu lingam" <spmlingam@gmail.com>)
Список pgsql-admin
On Mon, Mar 24, 2008 at 4:13 AM, petchimuthu lingam <spmlingam@gmail.com> wrote:
> How to enable bitmap heap scanning, my query is not using the scanning, i am
> using postgresql 8.1 version.
> i have enabled the option in the postgresql.conf, but still it is not using.

It's likely enabled, but the query planner thinks that another method
of doing things.  What does explain analyze select ... say about your
query plan?

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

Предыдущее
От: "Tena Sakai"
Дата:
Сообщение: Re: it refuses to go down...
Следующее
От: "sathiya psql"
Дата:
Сообщение: postgresql is slow with larger table even it is in RAM