Re: Suppressing unused subquery output columns

Поиск
Список
Период
Сортировка
От Jim Nasby
Тема Re: Suppressing unused subquery output columns
Дата
Msg-id 53923495.7010308@nasby.net
обсуждение исходный текст
Ответ на Re: Suppressing unused subquery output columns  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On 6/5/14, 9:54 PM, Tom Lane wrote:
> Rod Taylor <rod.taylor@gmail.com> writes:
>> On Thu, Jun 5, 2014 at 10:27 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>>> I'm not entirely convinced that it's worth the extra planning cycles,
>>> though.  Given the small number of complaints to date, it might not
>>> be worth doing this.  Thoughts?
>
>> Would this avoid execution of expensive functions in views when their
>> output is discarded?
>
> Yes, as long as they're not marked volatile and don't return sets.

That would certainly make it useful for us.
-- 
Jim C. Nasby, Data Architect                       jim@nasby.net
512.569.9461 (cell)                         http://jim.nasby.net



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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: Inaccuracy in VACUUM's tuple count estimates
Следующее
От: "David E. Wheeler"
Дата:
Сообщение: Re: Why is it "JSQuery"?