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

2009-09-02 Thread Christian Gonzalez
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:

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

2009-09-02 Thread Andrew Dunstan
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

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

2009-09-02 Thread Robert Haas
On Wed, Sep 2, 2009 at 11:29 AM, Christian Gonzalez wrote: > The point: > There is some way to keep objects in [persisten] memory and then refer to > these from c functions?.  In the current version of pgRoute, each > transaction load the graph in memory (using MemoryContext), this isn't a > enterp

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

2009-09-02 Thread Peter Eisentraut
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 ar

[HACKERS] c function: keep objects in memory for all session or all transaction

2009-09-02 Thread Christian Gonzalez
Hi everybody, I am new PostgreSQL c function programmer. I'm trying to move ahead a new "PostgreSQL routing library" (http://www.pgroute.org [for now, the page in only in spanish]). The point: There is some way to keep objects in [persisten] memory and then refer to these from c functions?