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