Re: [INTERFACES] OutOfMemoryException ??

From: Peter T Mount <peter(at)retep(dot)org(dot)uk>
To: John Reilly <jr(at)broadcom(dot)ie>
Cc: dicey(at)redbrick(dot)dcu(dot)ie, pgsql-interfaces(at)postgresql(dot)org, 93437307(at)dcu(dot)ie
Subject: Re: [INTERFACES] OutOfMemoryException ??
Date: 1998-07-10 17:51:56
Message-ID: Pine.LNX.3.96.980710185007.6715C-100000@maidast.retep.org.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)retep(dot)org(dot)uk or petermount(at)earthling(dot)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(at)maidstone(dot)gov(dot)uk

In response to

Browse pgsql-interfaces by date

  From Date Subject
Next Message Jeffrey Napolitano 1998-07-10 19:52:34 JDBC drivers
Previous Message Peter T Mount 1998-07-10 17:49:35 Re: [INTERFACES] postgres for spatial data