Re: Poor performance using CTE

Поиск
Список
Период
Сортировка
От Peter Geoghegan
Тема Re: Poor performance using CTE
Дата
Msg-id CAEYLb_WbXWZ6v4aDzNjrW71QNGe-gbvEW31zz++Yn9Csi2xo0Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Poor performance using CTE  (Heikki Linnakangas <hlinnakangas@vmware.com>)
Список pgsql-performance
On 21 November 2012 13:04, Heikki Linnakangas <hlinnakangas@vmware.com> wrote:
> Yes, I strongly feel that we should. Writing a query using WITH often makes
> it more readable. It would be a shame if people have to refrain from using
> it, because the planner treats it as an optimization fence.

+1

--
Peter Geoghegan       http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training and Services


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

Предыдущее
От: Heikki Linnakangas
Дата:
Сообщение: Re: Poor performance using CTE
Следующее
От: Shaun Thomas
Дата:
Сообщение: Re: Hints (was Poor performance using CTE)