Postgres Pro
Downloads
Home   >   mailing lists

Re: SPI memory managment issue - Mailing list pgsql-general

From Tom Lane
Subject Re: SPI memory managment issue
Date
Msg-id 12834.1078326536@sss.pgh.pa.us
Whole thread Raw
In response to SPI memory managment issue  (bsimon@loxane.com)
List pgsql-general
Tree view 
bsimon@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

pgsql-general by date:

Previous
From: Palle Girgensohn
Date:
Subject: Re: [ANNOUNCE] PostgreSQL 7.3.6 Now Available ...
Next
From: Pavel Stehule
Date:
Subject: Re: making a copy of a table within the same database