Re: [HACKERS] Memory leaks for large objects

On Wed, 18 Feb 1998, Maurice Gittens wrote:

> > >Does the large object I/O persist across transactions? If so, then
> storage would >need to be outside of the usual context, which is reset
> after every transaction. >Is there a place where the large object
> context could be freed, but is not at >the moment? > > - Tom

> Large object I/O does not persist across transactions in my case.

They do here when I've tried them.

> But maybe there are applications which assume that it does. So
> "fixing" it might break things. How about some compile time flag
> which selects between the old behaviour and new behaviour?
> The old behaviour could be the default.
>
> (The new behaviour would simply avoid fiddling with MemoryContexts at all.)
> My current workaround is to reconnect to the database after some
> number of transactions.

At the moment, JDBC defaults to not using transactions. As not many
java apps are using large objects yet (its a new 6.3 feature), it
shouldn't be difficult to disable the API's if autoCommit is enabled (aka
no transaction).

Thinking about it, the large object examples in the source tree use
transactions, so perhaps this is the original behaviour...

--
Peter T Mount petermount(at)earthling(dot)net or pmount(at)maidast(dot)demon(dot)co(dot)uk
Main Homepage: http://www.demon.co.uk/finder
Work Homepage: http://www.maidstone.gov.uk Work EMail: peter(at)maidstone(dot)gov(dot)uk