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

Поиск
Список
Период
Сортировка
От Andrew Dunstan
Тема Re: Pl/Perl function: Speed of the First time executing pl/perl function in connection;
Дата
Msg-id 4921ABE4.8070406@dunslane.net
обсуждение исходный текст
Ответ на Re: Pl/Perl function: Speed of the First time executing pl/perl function in connection;  (Hannu Krosing <hannu@krosing.net>)
Ответы Re: Pl/Perl function: Speed of the First time executing pl/perl function in connection;  (Hannu Krosing <hannu@2ndQuadrant.com>)
Список 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




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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: xmlconcat as variadic function
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Pl/Perl function: Speed of the First time executing pl/perl function in connection;