From: | Dave Cramer <pg(at)fastcrypt(dot)com> |
---|---|
To: | dmachop <dmachop(at)gmail(dot)com> |
Cc: | List <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: Postgres jdbc bulk insert stuck |
Date: | 2016-05-21 22:10:30 |
Message-ID: | CADK3HHJKGqumecSTPDbZ8x1L7U3-y=r_RCq8Jp82ssFrusQY7A@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Pretty sure we don't do single inserts.
Do you have a sense of where this breaks down. How many inserts it takes
before it fails ?
Dave Cramer
davec(at)postgresintl(dot)com
www.postgresintl.com
On 21 May 2016 at 16:34, dmachop <dmachop(at)gmail(dot)com> wrote:
> Tried with older version of postgres jdbc driver
> <
> http://mvnrepository.com/artifact/org.postgresql/postgresql/9.3-1104-jdbc41
> >
> and the issue still exists.
>
> I recollect reading from Stackoverflow that batch insert in postgres does
> individual inserts and recommends using copy. However, I cannot use copy
> due
> to certain reasons. That's the reason I have to resort to batch insert. Is
> there a way that I could change some parameters such that it might not hit
> the maximum limit? (Probably seems to be an issue with larger tables and
> batch insert works on smaller tables).
>
> Just an additional info that the data may contain non-ascii chars while
> insert (Chinese, German) and using utf-8 option on db as well as on jdbc
> connection properties. I don't see that as an issue since manual inserts
> are
> working good.
>
>
>
> --
> View this message in context:
> http://postgresql.nabble.com/Postgres-jdbc-bulk-insert-stuck-tp5904350p5904463.html
> Sent from the PostgreSQL - jdbc mailing list archive at Nabble.com.
>
>
> --
> Sent via pgsql-jdbc mailing list (pgsql-jdbc(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-jdbc
>
From | Date | Subject | |
---|---|---|---|
Next Message | Vitalii Tymchyshyn | 2016-05-21 22:17:18 | Re: Postgres jdbc bulk insert stuck |
Previous Message | Dave Cramer | 2016-05-21 22:06:27 | Re: [BUGS] BUG #13856: JDBC driver 1207 not picking up properties |