Re: pg_proc probin misuse

PFC <lists(at)peufeu(dot)com> writes:
>> If it were really expensive to derive bytecode from source text
>> then maybe it'd make sense to do what you're doing, but surely that's
>> not all that expensive. Everyone else manages to parse prosrc on the
>> fly and cache the result in memory; why isn't plpython doing that?

> It depends on the number of imported modules in the function. If it
> imports a lot of modules, it can take some time to compile a python
> function (especially if the modules have some initialisation code which
> must be run on import).

Surely the initialization code would have to be run anyway ... and if
the function does import a pile of modules, do you really want to cache
all that in its pg_proc entry? What happens if some of the modules get
updated later?

regards, tom lane