Re: View vs Stored Proc Performance - Mailing list pgsql-performance

From Dimitri Fontaine
Subject Re: View vs Stored Proc Performance
Date
Msg-id m2k504tm7y.fsf@hi-media.com
Whole thread Raw
In response to Re: View vs Stored Proc Performance  (Merlin Moncure <mmoncure@gmail.com>)
Responses Re: View vs Stored Proc Performance  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-performance
Merlin Moncure <mmoncure@gmail.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
views...

Regards,
--
dim

pgsql-performance by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: slow query : very simple delete, 100% cpu, nearly no disk activity
Next
From: Merlin Moncure
Date:
Subject: Re: View vs Stored Proc Performance