Re: c function: keep objects in memory for all session or all transaction

Peter Eisentraut wrote:
> On ons, 2009-09-02 at 10:59 -0430, Christian Gonzalez wrote:
>   
>> Is posible to put 
>> persisten object in memory through postgresql c funtion?
>>     
>
> Well, the PL/Perl and PL/Python languages do some variants of this using
> their GD and SD variables.  So it's surely possible in C as well.
> Memory contexts are the right keyword, but note that if you use
> TopMemoryContext, you are pretty much just using malloc().  Maybe you
> want to try prototyping your functionality in PL/Perl or PL/Python to
> get it started.
>
>   


But if you want something visible to all sessions, something like 
pg_memcache might be what you need. see 
<http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/~checkout~/pgmemcache/pgmemcache/README.pgmemcache?rev=1.11> 
for some details.

cheers

andrew