Avatar of Racim BOUDJAKDJI
Flag for Algeria

asked on 

Table valued vs OUT function's performance in postgresql

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.
> Locking

I would appreciate you enlighten me on the above.  Thank you for your help.

Avatar of undefined
Last Comment
earth man2

8/22/2022 - Mon