Re: View vs Stored Proc Performance

From: Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
To: Merlin Moncure <mmoncure(at)gmail(dot)com>
Cc: Jason Tesser <jasontesser(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: View vs Stored Proc Performance
Date: 2009-09-12 11:51:29
Message-ID: m2k504tm7y.fsf@hi-media.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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
views...

Regards,
--
dim

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Merlin Moncure 2009-09-12 13:22:50 Re: View vs Stored Proc Performance
Previous Message Merlin Moncure 2009-09-11 21:55:09 Re: slow query : very simple delete, 100% cpu, nearly no disk activity