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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
