Re: Pl/Perl function: Speed of the First time executing pl/perl function in connection; - Mailing list pgsql-hackers

I wrote:
> On my Fedora 9 machine, the overhead to start plperl seems to be about
> 40 msec.  This compares unfavorably to the time to start perl from the
> command line, which is under 4 msec.  I see that /usr/bin/perl pulls in
> libperl.so, so it's paying the same shlib overhead as we do.  How is it
> that we take ten times longer to start up?

The above number was for plperl in a SQL_ASCII database.
Some more data points:
    plperl        plperlu

SQL_ASCII    40        18
UTF8        67        18

which leads to the conclusion that those random little startup things
plperl does are just unbelievably expensive.
        regards, tom lane