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?
We run several instances of postgre in different countries, and we try keeping
them as same as possible, in terms of structure of the tables and function
definitions (except the content of schema "config", which differs between dbs).
So if we need to implement some different algorithm per countr
