Does PostgreSQL support the constant use of its pl * interpreters?

Question

If I wrote something in plperlu, when will this module restart? Every time a function was executed? For the first time? Does the Perl DLL unload if it has not been used after some time, and then another module will restart after that?

Answer 1

I think that the module will be loaded once for each server process (i.e. a new session / connection) the first time this language is used during this session.

You can preload them to avoid delays on first use, per guide forshared_preload_libraries and local_preload_libraries.

PostgreSQL preload_libraries; . , - .