Table valued vs OUT function's performance in postgresql
Posted on 2014-11-25
Hello fellow postgresql experts,
I was wandering about the opportunity to use table-valued functions vs functions returning output sets. From your experience, which one, assuming all indexes are in place, presents the best performance regarding :
> Concurrent accesses.
> Handling by the optimizer
> CPU and IO execution usage.
I would appreciate you enlighten me on the above. Thank you for your help.