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)2ndQuadrant(dot)com>
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 18:32:36
Message-ID: 4921B8C4.2000301@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hannu Krosing wrote:
>>
>> Neither of these would be the same as using plperl's %_SHARED, which I
>> gather is what is being done.
>>
>
> He asked for a method to get/set a shared value "with best performance"
> and updating a table row seems about twice as fast as calling a plperl
> function.
>
>
>> But using a temp table would be.
>>
>
> You can't access temp table from several sessions, which is what I think
> they want.
>
>

Well, neither is %_SHARED shared across backends, so if that's what they
want I'm wondering what exactly they are doing. Maybe using plperlu to
talk to some shared memory, or memcached, or some such.

cheers

andrew

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message David Fetter 2008-11-17 18:37:41 Re: pre-MED
Previous Message Simon Riggs 2008-11-17 18:13:12 Re: Updates of SE-PostgreSQL 8.4devel patches (r1197)