Thanks a lot Drew, for this good and well explained tip! Seems to work (I'll know better in a few days...) Using the values you propose appears also to speed up queries considerably on my system (well, maybe I am hallucinating out of enthusiasm :))!


On 13.11.2008, at 16:18, Drew Jensen wrote:

Rainer Schuetz wrote:

I'm using Base (3.0 on Mac Aqua with Leopard) with PostgreSQL 8.3.5 (connected with latest jdbc-driver) and lately get an error message about Java heap space once in a while when running a complex query:
- The data content could not be loaded. Java heap space
- More: The SQL command leading to this error is:
select replace(degree_dia(degree_alpha),' ','') AS tone, phase, maxphase, phase % 4 as mod4, phase % maxphase/2 AS modGonganHalve
FROM fgmiga_tones;

I don't understand what heap space is and wonder what I can do. It's not this specific query only that causes the problem.

Hi Rainer,

Well - I am sure someone will correct me if I am wrong on this.

There are two command line options available for Java that can be utilized here.

-Xmsn(k/m) - sets the Starting amount of memory to set aside for Java
-Xmxn(k/m) - sets the Maximum amount of memory that Java can allocate

For example then one could set the following options:

-Xms128m (this tells Java to start with 128 meg of memory)
-Xmx256m (tells Java to allocate up to 256 meg of memory - the default for this is 64 Meg by the way ) [note that each option ends with 'm' this is required to designate that the value is in Megs]

Adding start up options for Java under with the following:
Click the button 'Parameters'
The dialog "Java start parameters" is now displayed.
Enter the options in the 'Java start parameter' text box and click OK.
(any current options will be displayed in this dialog also)

----note here is where I am bit uncertain -----------------
I believe a new startup option was added to Java in one of the latest releases:

Which I believe allows Java to take all the memory you need till there is no more?



To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to