On Sat, Sep 12, 2009 at 7:51 AM, Dimitri Fontaine <[email protected]> wrote: > Merlin Moncure <[email protected]> writes: >> like joining the result to another table...the planner can see >> 'through' the view, etc. in a function, the result is fetched first >> and materialized without looking at the rest of the query. > > I though the planner would "see through" SQL language functions and > inline them when possible, so they often can make for parametrized > views...
It can happen for simple functions but often it will not. For views it always happens. merlin -- Sent via pgsql-performance mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
