Re: outOfMemoryError - Mailing list pgsql-jdbc

From Dave Cramer
Subject Re: outOfMemoryError
Date
Msg-id A45A5EE0-37AD-47D4-B578-12E3158901B0@fastcrypt.com
Whole thread Raw
In response to Re: outOfMemoryError  (Kris Jurka <books@ejurka.com>)
List pgsql-jdbc
On 29-Aug-06, at 8:47 PM, Kris Jurka wrote:

>
>
> On Tue, 29 Aug 2006, Dave Cramer wrote:
>
>> This design is limited by memory.
>>
>> You would be far better off inserting directly instead of using a
>> ResultSet
>
> Actually I think there is a point to be made here.  If the
> ResultSet is not scrollable then there is no need to store all the
> inserts that are made to it, so there should be no memory limit.

True, but this is hardly documented. It also suggests adding
complexity for a special case.
>
> Kris Jurka
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>


pgsql-jdbc by date:

Previous
From: Markus Schaber
Date:
Subject: Re: Encoding problem
Next
From: Tom Lane
Date:
Subject: Re: Could not determine data type of parameter $1