On Sat, Sep 12, 2009 at 7:51 AM, Dimitri Fontaine
> Merlin Moncure <mmoncure(at)gmail(dot)com> 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
It can happen for simple functions but often it will not. For views
it always happens.
In response to
pgsql-performance by date
|Next:||From: zz_11||Date: 2009-09-13 07:17:04|
|Subject: possible wrong query plan on pg 8.3.5,|
|Previous:||From: Dimitri Fontaine||Date: 2009-09-12 11:51:29|
|Subject: Re: View vs Stored Proc Performance|