Re: java.lang.OutOfMemoryError: GC overhead limit exceeded

Dear Jorge,

Thank you for the explanation and the pointer to the doc.

Indeed, the autocommit=false + fetchSize combo is working. I did a mistake when trying the first time as suggested by Vladimir: I used createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY) which are not the good parameters to be used (bad copy/paste).

With createStatement()+fetchSize+autocommit=false the exception disappeared.

Thank you very much.

Le jeudi 23 juillet 2020 à 16:31:06 UTC+2, Jorge Solórzano <jorsol@gmail.com> a écrit :

The only change that could affect between 42.2.10 (which works based
on your first message), and 42.2.11+ is the introduction of the tuple
abstraction.

The autocommit=false + fetchSize combo should help with large tables:
https://jdbc.postgresql.org/documentation/head/query.html#fetchsize-example