Re: Memory leaks using refcursors

Поиск
Список
Период
Сортировка
От Dave Cramer
Тема Re: Memory leaks using refcursors
Дата
Msg-id 123826E4-A0F1-4FE0-9726-2FD2ED26CDFB@fastcrypt.com
обсуждение исходный текст
Ответ на Re: Memory leaks using refcursors  ("Guillaume Smet" <guillaume.smet@gmail.com>)
Ответы Max size for bytea type  ("Do, Leon \(Leon\)" <leondo@alcatel-lucent.com>)
Re: Memory leaks using refcursors  (Kris Jurka <books@ejurka.com>)
Список pgsql-jdbc
On 19-Jan-07, at 11:07 AM, Guillaume Smet wrote:

> On 1/19/07, Dave Cramer <pg@fastcrypt.com> wrote:
>> I believe the problem is in the server's  XA code somehow not closing
>> unnamed parameters properly.
>>
>> If you could run the code I sent you and tell me if it causes a leak,
>> then that will confirm it.
>
> Sorry, I did not understand what you've asked me. I just run the test
> without the XA code and it has the memory leak with the old 408
> driver.
> IMHO, it's quite logical as this memory leak has nothing to do with
> the transaction management as all the operations are in a big
> transaction.
> When I close the transaction, XA or not XA, the backend used by the
> connection returns to a normal memory usage.

So I've sent Guillaume a driver which closes the refcursor directly
after reading the contents for testing.

So far so good.

Dave
>
> --
> Guillaume
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>


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

Предыдущее
От: "Guillaume Smet"
Дата:
Сообщение: Re: Memory leaks using refcursors
Следующее
От: "Do, Leon \(Leon\)"
Дата:
Сообщение: Max size for bytea type