SPI memory managment issue

Поиск
Список
Период
Сортировка
От bsimon@loxane.com
Тема SPI memory managment issue
Дата
Msg-id OF539ADD90.E493F3D8-ONC1256E4C.00449B72-C1256E4C.00449C9C@beauchamp.loxane.fr
обсуждение исходный текст
Ответы Re: SPI memory managment issue  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general

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.

В списке pgsql-general по дате отправления:

Предыдущее
От: Will Newton
Дата:
Сообщение: Selecting reals into doubles
Следующее
От: Lincoln Yeoh
Дата:
Сообщение: Re: Moving from MySQL to PGSQL....some questions