Re: Is There Any Way .... - Mailing list pgsql-performance

From Richard Huxton
Subject Re: Is There Any Way ....
Date
Msg-id 433CE5DE.8090004@archonet.com
Whole thread Raw
In response to Is There Any Way ....  ("Lane Van Ingen" <lvaningen@esncc.com>)
List pgsql-performance
Lane Van Ingen wrote:
>   (2) Set up user variables in memory that are persistent across all
> sessions, for
>       as long as the database is up and running ?

You could probably write "C" functions (or possibly Perl) to store data
in shared memory. Of course you'd have to deal with concurrency issues
yourself.

Storing the values in a table and having cached access to them during
the session is probably your best bet.

--
   Richard Huxton
   Archonet Ltd

pgsql-performance by date:

Previous
From: "Magnus Hagander"
Date:
Subject: Re: Comparative performance
Next
From: xchris
Date:
Subject: Lists or external TABLE?