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
hannu=# create table shvaltable(id int, value bigint);
CREATE TABLE
Time: 34.704 ms
hannu=# insert into shvaltable values(1,0);
INSERT 0 1
Time: 0.742 ms
hannu=# explain analyse update shvaltable set value=47 where id=1;
QUERY
PLAN
-------------------------------------------------------------------------------------------------------
Seq Scan on shvaltable (cost=0.00..34.25 rows=10 width=10) (actual
time=0.015..0.017 rows=1 loops=1)
Filter: (id = 1)
Total runtime: 0.073 ms
(3 rows)
Time: 3.503 ms
hannu=# explain analyse update shvaltable set value=47 where id=1;
QUERY
PLAN
-------------------------------------------------------------------------------------------------------
Seq Scan on shvaltable (cost=0.00..34.25 rows=10 width=10) (actual
time=0.014..0.016 rows=1 loops=1)
Filter: (id = 1)
Total runtime: 0.058 ms
(3 rows)
Time: 3.298 ms
> 2008/11/16 Tom Lane <[EMAIL PROTECTED]>:
> > "Oleg Serov" <[EMAIL PROTECTED]> writes:
> >> So, how i must optimize it?
> >
> > The short-term answer seems to be "preload and use plperlu".
> >
> > regards, tom lane
> >
>
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
