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

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: Hannu Krosing <hannu(at)krosing(dot)net>
Cc: Oleg Serov <serovov(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, 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-17 17:37:40
Message-ID: 4921ABE4.8070406@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2008-11-17 17:53:12 Re: Pl/Perl function: Speed of the First time executing pl/perl function in connection;
Previous Message Tom Lane 2008-11-17 17:34:11 Re: xmlconcat as variadic function