Tom Lane wrote:
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.
I suspect much of this time is taken in loading perl modules, (strict,
Safe, utf8, SPI among others), not in anything very special that we do.:
[EMAIL PROTECTED] plperl]$ time perl -e ';'
real 0m0.004s
user 0m0.003s
sys 0m0.001s
[EMAIL PROTECTED] plperl]$ time perl -e 'use strict; use Safe;use utf8;'
real 0m0.053s
user 0m0.016s
sys 0m0.007s
cheers
andrew
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
