Re: View vs Stored Proc Performance

From: Merlin Moncure <mmoncure(at)gmail(dot)com>
To: Jason Tesser <jasontesser(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: View vs Stored Proc Performance
Date: 2009-09-11 17:37:57
Message-ID: b42b73150909111037g45c715dft34c4c007fd26c535@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Fri, Sep 11, 2009 at 11:46 AM, Jason Tesser <jasontesser(at)gmail(dot)com> wrote:
> Is it faster to use a Stored Proc that returns a Type or has Out Parameters
> then a View?  Views are easier to maintain I feel.  I remember testing this
> around 8.0 days and the view seemed slower with a lot of data.

for the most part, a view can be faster and would rarely be slower.
Views are like C macros for you query...they are expanded first and
then planned. Functions (except for very simple ones) are black boxes
to the planner and can materially hurt query performance in common
cases. The only case where a function would win is when dealing with
conner case planner issues (by forcing a nestloop for example).

merlin

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Scott Carey 2009-09-11 18:02:35 Re: odd iostat graph
Previous Message Alan McKay 2009-09-11 16:58:33 odd iostat graph