Re: Planner picking topsey turvey plan?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Planner picking topsey turvey plan?
Дата
Msg-id 5092.1228701731@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Planner picking topsey turvey plan?  (Glyn Astill <glynastill@yahoo.co.uk>)
Ответы Re: Planner picking topsey turvey plan?  (Glyn Astill <glynastill@yahoo.co.uk>)
Список pgsql-general
Glyn Astill <glynastill@yahoo.co.uk> writes:
> Does anyone know how I can change what I'm doing to get pgsql to pick a better plan?

You've provided no evidence that this is a bad plan.

In particular, the plan you seem to think would be better would involve
an estimated 153 iterations of the cost-15071 hash aggregation, which
simple arithmetic shows is more expensive than the plan it did choose.

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: COPY error with null date
Следующее
От: "Dot Yet"
Дата:
Сообщение: Re: Unique constaint violated without being violated