Re: Postgres not using indices defined on my table with certain queries using "in"

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Postgres not using indices defined on my table with certain queries using "in"
Дата
Msg-id 3473.1183608503@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Postgres not using indices defined on my table with certain queries using "in"  ("s anwar" <sanwar@gmail.com>)
Ответы Re: Postgres not using indices defined on my table with certain queries using "in"  ("s anwar" <sanwar@gmail.com>)
Список pgsql-novice
Дерево обсуждения 
"s anwar" <sanwar@gmail.com> writes:
> The two queries blow require radically different query times 1600ms vs 10ms:

Try not to be so fancy with a bunch of somewhat-overlapping partial indexes.
The planner is not so smart as you, and will not always be able to prove
to itself that it can use these indexes.  A single, non-partial index on
ock would perform at least as well as this hodgepodge.

            regards, tom lane

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

Предыдущее
От: "s anwar"
Дата:
Сообщение: Postgres not using indices defined on my table with certain queries using "in"
Следующее
От: mike lane
Дата:
Сообщение: how to get pg_dump in postgesql 8.2 to create inserts with E'....' for back slashes