Postgres Pro
Downloads
Home   >   mailing lists

Re: java.lang.OutOfMemoryError: GC overhead limit exceeded - Mailing list pgsql-jdbc

From Christophe combet
Subject Re: java.lang.OutOfMemoryError: GC overhead limit exceeded
Date
Msg-id 1623541738.9101116.1595510491187@mail.yahoo.com
Whole thread Raw
In response to Re: java.lang.OutOfMemoryError: GC overhead limit exceeded  (Christophe combet <chrisc_pro@yahoo.fr>)
Responses Re: java.lang.OutOfMemoryError: GC overhead limit exceeded
Re: java.lang.OutOfMemoryError: GC overhead limit exceeded
List pgsql-jdbc
Tree view

autocommit=false & fetchSize=100 or 10000 : same exception.

42.2.10 still running.
Le jeudi 23 juillet 2020 à 14:30:56 UTC+2, Christophe combet <chrisc_pro@yahoo.fr> a écrit :



Thank you for pointing the link between auto commit an buffering.

autocommit=false: same exception.

We try fetchSize.

Thanks.
Le jeudi 23 juillet 2020 à 13:47:14 UTC+2, Vladimir Sitnikov <sitnikov.vladimir@gmail.com> a écrit :


>can you try switching to autocommit=false?

+ you probably need to configure fetchSize as well.

Vladimir

pgsql-jdbc by date:

Previous
From: Christophe combet
Date:
Subject: Re: java.lang.OutOfMemoryError: GC overhead limit exceeded
Next
From: Dave Cramer
Date:
Subject: Re: java.lang.OutOfMemoryError: GC overhead limit exceeded