Re: Suppressing unused subquery output columns - Mailing list pgsql-hackers

From Jim Nasby
Subject Re: Suppressing unused subquery output columns
Date
Msg-id 53923495.7010308@nasby.net
Whole thread Raw
In response to Re: Suppressing unused subquery output columns  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Andres Freund
Date:
Subject: Re: Inaccuracy in VACUUM's tuple count estimates
Next
From: "David E. Wheeler"
Date:
Subject: Re: Why is it "JSQuery"?