Re: SPI memory managment issue

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: bsimon(at)loxane(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: SPI memory managment issue
Date: 2004-03-03 15:08:56
Message-ID: 12834.1078326536@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

bsimon(at)loxane(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2004-03-03 15:11:10 Re: making a copy of a table within the same database
Previous Message Palle Girgensohn 2004-03-03 15:07:16 Re: [ANNOUNCE] PostgreSQL 7.3.6 Now Available ...