By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,773 Members | 1,226 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,773 IT Pros & Developers. It's quick & easy.

SPI memory managment issue

P: n/a
I've read in the doc that every memory allocation done in a spi memory
context was freed at the end of the context (after spi_finish)
What happens if the context is is initialized inside another one ?

Here is my function :

spi_connect()

execute query1;
...
execute query10;

spi_finish()

The thing is that I do another spi_connect inside all subqueries (query1
.... query10) and the memory allocated inside all "subcontext" doesn't
seems to be freed until the last call of spi_finish. (the one of the
"big" function).

Hopefully I was clear enough :)
Any help ?

Benjamin.
Nov 23 '05 #1
Share this Question
Share on Google+
1 Reply

P: n/a
bs****@loxane.com writes:
The thing is that I do another spi_connect inside all subqueries (query1
... query10) and the memory allocated inside all "subcontext" doesn't
seems to be freed until the last call of spi_finish. (the one of the
"big" function).


No, spi_finish frees memory used in that particular SPI invocation.
What's your evidence for thinking otherwise?

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Nov 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.