Skip site navigation (1) Skip section navigation (2)

View vs Stored Proc Performance

From: Jason Tesser <jasontesser(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: View vs Stored Proc Performance
Date: 2009-09-11 15:46:10
Message-ID: 98bbb46a0909110846ue8044bdk46c6302ce9db8d35@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
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.

Responses

pgsql-performance by date

Next:From: Alan McKayDate: 2009-09-11 16:58:33
Subject: odd iostat graph
Previous:From: A. KretschmerDate: 2009-09-11 05:33:08
Subject: Re: PSQL 8.4 - partittions - join tables - not optimal plan

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group