Re: PostgreSQL and Performance of Functions - Mailing list pgsql-admin

From Peter Eisentraut
Subject Re: PostgreSQL and Performance of Functions
Date
Msg-id 200612020233.39653.peter_e@gmx.net
Whole thread Raw
In response to Re: PostgreSQL and Performance of Functions  ("Aaron Bono" <postgresql@aranya.com>)
List pgsql-admin
Aaron Bono wrote:
> I was told that, for DB2, stored procedures are a better choice for
> parameterized views which is what I was trying to do with the
> functions.  Is the same true for PostgreSQL?

That depends somewhat on the meaning of "better", but on average a view
should be preferred if possible.  It's easier to set up, easier to
debug, and at least as efficient.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Problem restoring with pg_dump
Next
From: Peter Wilson
Date:
Subject: Re: Problem restoring with pg_dump