Re: function returning setof performance question

Mark Bronnimann wrote:
> I was hoping to eliminate the parse call on the view because I was doing
> the where clause on the view instead of putting the where in the view.
> In all, I was hoping to keep a single view called from multiple functions
> with different where clauses. Yep... I shoulda known better...
>

It sounds like you're using a sql function, not a plpgsql function
(although I don't think you said either way). If you write the function
in plpgsql it will get parsed and cached on the first call in a
particular backend session, which *might* give you improved performance
on subsequent calls, if there are any; are you using persistent connections?

Alternatively, it might work to use a prepared query.

Joe