Postgres Pro
Downloads
Home   >   mailing lists

View vs Stored Proc Performance - Mailing list pgsql-performance

From Jason Tesser
Subject View vs Stored Proc Performance
Date
Msg-id 98bbb46a0909110846ue8044bdk46c6302ce9db8d35@mail.gmail.com
Whole thread Raw
Responses Re: View vs Stored Proc Performance
List pgsql-performance
Tree view
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.

pgsql-performance by date:

Previous
From: "A. Kretschmer"
Date:
Subject: Re: PSQL 8.4 - partittions - join tables - not optimal plan
Next
From: Alan McKay
Date:
Subject: odd iostat graph