Postgres Pro
Downloads
Home   >   mailing lists

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

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


On Thu, 23 Jul 2020 at 09:21, Christophe combet <chrisc_pro@yahoo.fr> wrote:

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

42.2.10 still running.

Is there a very large column in there 


Dave Cramer
www.postgres.rocks



 
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: Rob Sargent
Date:
Subject: Re: java.lang.OutOfMemoryError: GC overhead limit exceeded