Re: Pl/Perl function: Speed of the First time executing pl/perl function in connection;

Oleg Serov wrote:
> When perl function executes first time, it is too slowly, but if
> execute perl function(not function which executed first time) again it
> runs in 1000 times faster. Why ? how can i optimize it ?
> Configure shared_preload_libraries = '$libdir/plperl' or
> local_preload_libraries = '$libdir/plugins/plperl' does not help;
>
>

The function is recompiled on the first call in each backend. (The same
is true of most PLs, BTW, it's not a perl-only problem.) There is no
immediate cure, unfortunately. Using pooled connections might help to
mitigate the effect.

One might imagine providing for certain functions to be loaded on
backend startup, or even (where we aren't using BACKEND_EXEC) on
postmaster start. But that would be a new feature, and we are past
feature freeze for the upcoming release, so it's not going to happen any
time soon.

cheers

andrrew