Slow performance with 9.3-110x JDBC 4

From: ChatPristi <cchristo_0899(at)yahoo(dot)fr>
To: "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Slow performance with 9.3-110x JDBC 4
Date: 2014-03-27 13:35:34
Message-ID: 1395927334.64921.YahooMailNeo@web28904.mail.ir2.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Dear All,
I have a java program that does bulk insertions (with transactions and PreparedStatements) in a postgresql database. I have a performance divided between two and four when using 9.3-1100 JDBC4 and 9.3-1101 in comparison with postgresql-8.4-703 JDBC4 independently of postgresql version.

 Time(ms)                PG     8.4.7            9.3.4
Driver
8.4-703                          193390         188379
9.3.1101                         349404        344344

Does anybody else saw such a difference ? What reasons can explain it ?

Another point, is that the bulk insertions are prerformed by parallel processes and 9.3-110x JDBC4 drivers appear to scale poorly.

Thanks for any help.

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2014-03-27 13:54:41 Re: Slow performance with 9.3-110x JDBC 4
Previous Message Dave Cramer 2014-03-26 14:24:39 Re: link to file bug against Postgres JDBC driver