| From: | Dave Cramer <davecramer(at)postgres(dot)rocks> |
|---|---|
| To: | Christophe combet <chrisc_pro(at)yahoo(dot)fr> |
| Cc: | Vladimir Sitnikov <sitnikov(dot)vladimir(at)gmail(dot)com>, pgsql-jdbc(at)lists(dot)postgresql(dot)org |
| Subject: | Re: java.lang.OutOfMemoryError: GC overhead limit exceeded |
| Date: | 2020-07-23 13:24:29 |
| Message-ID: | CADK3HH+HcaSEMxnwv36GZsk9HygpCO7T45SKvzeMCSSPYjVVCw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
On Thu, 23 Jul 2020 at 09:21, Christophe combet <chrisc_pro(at)yahoo(dot)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(at)yahoo(dot)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(dot)vladimir(at)gmail(dot)com> a écrit :
>
>
> >can you try switching to autocommit=false?
>
> + you probably need to configure fetchSize as well.
>
> Vladimir
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rob Sargent | 2020-07-23 13:33:25 | Re: java.lang.OutOfMemoryError: GC overhead limit exceeded |
| Previous Message | Christophe combet | 2020-07-23 13:21:31 | Re: java.lang.OutOfMemoryError: GC overhead limit exceeded |