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

Ohh Thanks to all for your answers,    pgmemcache does exactly what I need, or how I need it, that is to 
put my graph into a persistent memory for all transactions that have 
permissions.

Thanks again,
Christian Gonzalez

El 02/09/09 14:47, Andrew Dunstan escribió:
>
>
> 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
>