Re: The planner chooses seqscan+sort when there is an

Поиск
Список
Период
Сортировка
От Csaba Nagy
Тема Re: The planner chooses seqscan+sort when there is an
Дата
Msg-id 1146672070.14093.180.camel@coppola.muc.ecircle.de
обсуждение исходный текст
Ответ на Re: The planner chooses seqscan+sort when there is an index on the sort column  (Andreas Kretschmer <akretschmer@spamfence.net>)
Ответы Re: The planner chooses seqscan+sort when there is an  ("John D. Burger" <john@mitre.org>)
Список pgsql-general
> Without a WHERE you get the whole table.
>
> A Index-Scan is, in this case, expensive.

I know that, and I would agree if I wouldn't have asked for _ordered_
result, and wouldn't have turned enable_seqscan=off.

In these conditions I would have expected an index scan, even if it is
more expensive than the sequential scan + sort. Actually I wanted to see
how expensive it thinks it is, but I can't get to that plan at all.

Thanks,
Csaba.



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

Предыдущее
От: Csaba Nagy
Дата:
Сообщение: Re: The planner chooses seqscan+sort when there is an
Следующее
От: "Magnus Hagander"
Дата:
Сообщение: Re: logfiles filling up