Re: BUG #1393: Adding 'LIMIT 1' to the query halts forever

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #1393: Adding 'LIMIT 1' to the query halts forever
Дата
Msg-id 19671.1105909715@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: BUG #1393: Adding 'LIMIT 1' to the query halts forever  (Michael Fuhr <mike@fuhr.org>)
Ответы Re: BUG #1393: Adding 'LIMIT 1' to the query halts forever  (Michael Fuhr <mike@fuhr.org>)
Список pgsql-bugs
Michael Fuhr <mike@fuhr.org> writes:
> Would it be accurate to say that the planner makes the bet most
> likely to win without regard to how badly it might lose?

Yes, I think that's a fair summary.

> Is taking the downside into consideration a tough problem to solve, or
> is it simply not worthwhile in the large?

I don't know how to solve it, and whether it would be worthwhile would
depend considerably on how expensive the proposed solution is ...

            regards, tom lane

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

Предыдущее
От: "Luiz Gonzaga da Mata"
Дата:
Сообщение: Re: Bug in check constraint?
Следующее
От: Josh Berkus
Дата:
Сообщение: Error in 8.0 rc5 with repeat calls to array operator