So, how i must optimize it? 2008/11/16 Andrew Dunstan <[EMAIL PROTECTED]>: > > > 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