Re: PostgreSQL JDBC - Long Running Stored Procedure - Out of Memory

Andrea Lombardoni wrote:
>>> I solved my problem, but really, why does the PostgreSQL JDBC driver
>>> have to keep in memory all the RAISE NOTICE texts?
>>> Can't they simply be discarded/ignored?
>> The notices are available from Statement.getWarnings().
> 
> Is there a way to make the JDBC driver ignore them?
> 
>> Why output them if
>> you were just going to throw them away?
> 
> They are meant to be stored in the PostgreSQL server logs (and later
> analyzed), but there is no use for them on the Java side.
> 

If you don't want them sent to the client, you should adjust the setting 
of client_min_messages to a higher value to keep them from being sent to 
the JDBC driver at all.

Kris Jurka