Re: Memory leaks using refcursors - Mailing list pgsql-jdbc

From Dave Cramer
Subject Re: Memory leaks using refcursors
Date
Msg-id 123826E4-A0F1-4FE0-9726-2FD2ED26CDFB@fastcrypt.com
Whole thread Raw
In response to Re: Memory leaks using refcursors  ("Guillaume Smet" <guillaume.smet@gmail.com>)
Responses Max size for bytea type
Re: Memory leaks using refcursors
List 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 by date:

Previous
From: "Guillaume Smet"
Date:
Subject: Re: Memory leaks using refcursors
Next
From: "Do, Leon \(Leon\)"
Date:
Subject: Max size for bytea type