Re: View vs function - Mailing list pgsql-performance

From Neil Conway
Subject Re: View vs function
Date
Msg-id 423E57E5.4070405@samurai.com
Whole thread Raw
In response to Re: View vs function  (Bruno Wolff III <bruno@wolff.to>)
Responses Re: View vs function  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
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.

-Neil

pgsql-performance by date:

Previous
From: "Stacy White"
Date:
Subject: Re: What needs to be done for real Partitioning?
Next
From: "Stacy White"
Date:
Subject: Re: What needs to be done for real Partitioning?