Re: Are stored procedures always kept in memory?

Hello

>
>
> Now my questions is: Are the stored functions (both plpgsql and plain sql
> functions) kept always in a memory? Or they are stored similarly like
> tables, on the disk, reading them into memory when called and possibly
> release them from memory, if memory is needed for something else?

procedures living in pg_proc table. Before call procedure is loaded,
compiled (to abstract syntax tree) and compiled code (tree) is stored
to session cache. Cache is released after logout or function's update.

Regards

Pavel Stehule

>
>
>
> Thanks for reply.
>
>
>
> R.G.
>
>
>
> ________________________________
> Disclaimer: http://www.aps-holding.com/disclaimer.html