Re: Optimizer isn't perfect

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Optimizer isn't perfect
Дата
Msg-id 27639.1062173464@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Optimizer isn't perfect  (Greg Stark <gsstark@mit.edu>)
Список pgsql-general
Greg Stark <gsstark@mit.edu> writes:
> This is the same thing someone else pointed out a while ago. The consequences
> of guessing wrong and favouring a full table scan instead of index lookups
> with nested loops are simply much more severe than the reverse.

It is easy to demonstrate cases where this isn't true.

            regards, tom lane

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