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

From Andrew Dunstan
Subject Re: Pl/Perl function: Speed of the First time executing pl/perl function in connection;
Date
Msg-id 49202B00.7090207@dunslane.net
Whole thread Raw
In response to Re: Pl/Perl function: Speed of the First time executing pl/perl function in connection;  ("Oleg Serov" <serovov@gmail.com>)
Responses Re: Pl/Perl function: Speed of the First time executing pl/perl function in connection;
Re: Pl/Perl function: Speed of the First time executing pl/perl function in connection;
List pgsql-hackers


Oleg Serov wrote:
> Hey, you are wrong, compile time is 1 ms, but not 100 ms, it hapens on
> first plperl function call, it is perl init problem. not function
> compilation.
>   

Please do NOT top-answer - it makes threads totally unreadable.

Is a one-off cost per connection of 100ms so bothersome?

The alternative would be to start it up when the backend starts, but 
backend startup cost is already high, so that doesn't seem like a win.

cheers

andrew




pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: CVS can't be built on mingw
Next
From: Tom Lane
Date:
Subject: Re: CVS can't be built on mingw