Re: [INTERFACES] OutOfMemoryException ?? - Mailing list pgsql-interfaces

From Peter T Mount
Subject Re: [INTERFACES] OutOfMemoryException ??
Date
Msg-id Pine.LNX.3.96.980710185007.6715C-100000@maidast.retep.org.uk
Whole thread Raw
In response to OutOfMemoryException ??  (John Reilly <jr@broadcom.ie>)
List pgsql-interfaces
On Fri, 10 Jul 1998, John Reilly wrote:

> Hi all,
>     Someone wrote asking about an out of memory exception recently.
> I had a similar problem with javac.
>
> The solution : give the jvm more memory with the -mx switch
>
> java -mx48m .......
> to give it 48 Megs.
>
> The default is 16M

I forgot about that one. I'll add it to the JDBC driver's documentation.

This can be a problem when queries return a lot of results. Another way
around it would be to use cursors with the queries when ever possible.

--
Peter T Mount peter@retep.org.uk or petermount@earthling.net
Main Homepage: http://www.retep.org.uk
************ Someday I may rebuild this signature completely ;-) ************
Work Homepage: http://www.maidstone.gov.uk Work EMail: peter@maidstone.gov.uk


pgsql-interfaces by date:

Previous
From: Peter T Mount
Date:
Subject: Re: [INTERFACES] postgres for spatial data
Next
From: Jeffrey Napolitano
Date:
Subject: JDBC drivers