Re: FW: Java Memory Issue while Loading Postgres library - Mailing list pgsql-general

From
Subject Re: FW: Java Memory Issue while Loading Postgres library
Date
Msg-id 4AD2336877609F41A2B0D53BAD09FC570107D8ED@VOO-EXCHANGE07.internal.sungard.corp
Whole thread Raw
In response to Re: FW: Java Memory Issue while Loading Postgres library  (Craig Ringer <craig@postnewspapers.com.au>)
List pgsql-general

-----Original Message-----
From: Craig Ringer [mailto:craig@postnewspapers.com.au]
Sent: Friday, April 30, 2010 12:01 PM
To: Arya, Ashish
Cc: pgsql-general@postgresql.org; Bhattacharya, A
Subject: Re: FW: [GENERAL] Java Memory Issue while Loading Postgres
library

Hi

Did you eventually figure out what was wrong?

Was it just that you were trying to load a full result set and running
out of memory with an OutOfMemoryError?

Or was the jvm truly crashing rather than just throwing
OutOfMemoryError?

--
Craig Ringer

---------------
Thanks Craig for your inputs.

However, we identified the problem as " OutOfMemoryError" and it was
thrown from Java  because of unnecessary "Raise info message"  from our
program.
Thus we have set the client_min_messages and log_min_messages to 'error'
level and switched off the messages from our program  has solved the
problem.

Please if anyone face the same issue refer to the below link.

http://archives.postgresql.org/pgsql-jdbc/2009-01/msg00068.php

Many thanks
AB


pgsql-general by date:

Previous
From: Vincenzo Romano
Date:
Subject: Re: Inheritance efficiency
Next
From: Jorge Arevalo
Date:
Subject: Re: Writing SRF