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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Pl/Perl function: Speed of the First time executing pl/perl function in connection;
Дата
Msg-id 537.1226854833@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Pl/Perl function: Speed of the First time executing pl/perl function in connection;  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Pl/Perl function: Speed of the First time executing pl/perl function in connection;  (Andrew Dunstan <andrew@dunslane.net>)
Список 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


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Pl/Perl function: Speed of the First time executing pl/perl function in connection;
Следующее
От: Michael Meskes
Дата:
Сообщение: Re: [COMMITTERS] pgsql: Enable script to generate preproc.y in build process.