Re: Strange Index behavior

Поиск
Список
Период
Сортировка
От Bruno Wolff III
Тема Re: Strange Index behavior
Дата
Msg-id 20041222181115.GA500@wolff.to
обсуждение исходный текст
Ответ на Re: Strange Index behavior  (Együd Csaba (Freemail) <csegyud@freemail.hu>)
Список pgsql-general
On Wed, Dec 22, 2004 at 18:44:00 +0100,
  "Együd Csaba (Freemail)" <csegyud@freemail.hu> wrote:
> But why? I thought the planner is for choose the quicker way to the target
> point. If there is an index which is probably would speed up the query then
> why does the planner ignore that?

Because doing an index scan is slower if you are retrieving a significant
(very roughly 5%) fraction of a table.

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

Предыдущее
От: "Magnus Hagander"
Дата:
Сообщение: Re: 8.0 Beta3 worked, RC1 didn't!
Следующее
От: "A. Mous"
Дата:
Сообщение: Re: 8.0 Beta3 worked, RC1 didn't!