Re: View vs function - Mailing list pgsql-performance

From Tom Lane
Subject Re: View vs function
Date
Msg-id 11188.1111387242@sss.pgh.pa.us
Whole thread Raw
In response to Re: View vs function  (Neil Conway <neilc@samurai.com>)
List pgsql-performance
Neil Conway <neilc@samurai.com> writes:
> Bruno Wolff III wrote:
>> Functions are just black boxes to the planner.

> ... unless the function is a SQL function that is trivial enough for the
> planner to inline it into the plan of the invoking query. Currently, we
> won't inline set-returning SQL functions that are used in the query's
> rangetable, though. This would be worth doing, I think -- I'm not sure
> how much work it would be, though.

Yeah, I've been thinking the same.  It seems like it shouldn't be unduly
difficult --- not harder than inlining scalar-valued SQL functions, just
different validity conditions.

            regards, tom lane

pgsql-performance by date:

Previous
From: "Stacy White"
Date:
Subject: Re: What needs to be done for real Partitioning?
Next
From: Richard Huxton
Date:
Subject: Re: Hardware impact on performances