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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Andrew Dunstan <andrew(at)dunslane(dot)net>
Cc: Oleg Serov <serovov(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Pl/Perl function: Speed of the First time executing pl/perl function in connection;
Date: 2008-11-16 17:00:33
Message-ID: 537.1226854833@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Meskes 2008-11-16 17:01:13 Re: pgsql: Enable script to generate preproc.y in build process.
Previous Message Martijn van Oosterhout 2008-11-16 16:46:54 Re: Pl/Perl function: Speed of the First time executing pl/perl function in connection;