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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-performance by date

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