From: Eric.Boyer at insa-toulouse.fr (Eric BOYER)
Date: Fri, 16 Jun 2006 11:04:13 +0200
Subject: [Pljava-dev] java.lang.OutOfMemoryError
Message-ID: <4492740D.4040302@insa-toulouse.fr>

Hello

We use pl java to launch an application

org.postgresql.util.PSQLException: ERREUR: java.lang.OutOfMemoryError
        at 
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1512)
        at 
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1297)
        at 
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
        at 
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:437)
        at 
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:339)
        at 
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:331)

We have a long treatment in a loop and the memory grow gradually up to a 
java.lang.OutOfMemoryError.

What could be the problem ?

- garbage collector ?
- vmoptions ? : pljava.vmoptions = '-Xmx64M'

Our serveur have 1Go RAM and postmaster start with a low consumption of 
RAM and grow up to ~300M ...

Thanks for your help

Eric