Postgres Pro
Downloads
Home   >   mailing lists

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 4921ABE4.8070406@dunslane.net
Whole thread Raw
In response to Re: Pl/Perl function: Speed of the First time executing pl/perl function in connection;  (Hannu Krosing <hannu@krosing.net>)
Responses Re: Pl/Perl function: Speed of the First time executing pl/perl function in connection;  (Hannu Krosing <hannu@2ndQuadrant.com>)
List pgsql-hackers
Tree view 

Hannu Krosing wrote:
> On Sun, 2008-11-16 at 23:20 +0300, Oleg Serov wrote:
>   
>> Wee need to use shared memory for passing one BIGINT value(is session
>> throwout triggers), can you advice the method to get/set it with best
>> performance ?
>>     
>
> have you tried "setval(seq, value)" to set and "select last_value from
> seq" to read it.
>
> or just use a table, if concurrency control is important
>   

Neither of these would be the same as using plperl's %_SHARED, which I 
gather is what is being done. But using a temp table would be.

cheers

andrew

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: xmlconcat as variadic function
Next
From: Tom Lane
Date:
Subject: Re: Pl/Perl function: Speed of the First time executing pl/perl function in connection;