Re: wide row insert via Postgres jdbc driver

Sameer Kumar schrieb am 23.09.2014 um 07:24:
> I am working with a vendor and planning to deploy their application
> on PostgreSQL as backend. They have cautioned the customer that
> PostgreSQL's jdbc driver v9.1 (build 900) has issues which causes
> deadlocks while "wide record inserts".

Can you be a bit more explicit?
I have never heard the term "wide record inserts" before


> Is there any such known problem which anyone else has encountered in
> this regards? Has there been any improvements in future
> builds/releases on this aspect of PostgreSQL drivers/connectors?

I have never seen any deadlocks in Postgres that were caused by the driver or Postgres itself.

Deadlocks are almost always caused by sloppy programming.

My guess is that this vendor initially supported "some other" database
with less strict transaction handling or even a DBMS where the couldn't
(or didn't want to) use transactions.