Re: wide row insert via Postgres jdbc driver

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: wide row insert via Postgres jdbc driver
Date: 2014-09-23 12:12:22
Message-ID: lvro36$3m1$1@ger.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Eugenio Trumpy 2014-09-23 12:13:30 Re: csv import error
Previous Message Seref Arikan 2014-09-23 11:26:38 Re: Where art thou, plpython2.dll? (EDB installer)