Postgres Pro
Downloads
Home   >   mailing lists

Slow performance with 9.3-110x JDBC 4 - Mailing list pgsql-jdbc

From ChatPristi
Subject Slow performance with 9.3-110x JDBC 4
Date
Msg-id 1395927334.64921.YahooMailNeo@web28904.mail.ir2.yahoo.com
Whole thread Raw
Responses Re: Slow performance with 9.3-110x JDBC 4  (Dave Cramer <davecramer@gmail.com>)
Re: Slow performance with 9.3-110x JDBC 4  (Lachezar Dobrev <l.dobrev@gmail.com>)
List pgsql-jdbc
Tree view
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.

pgsql-jdbc by date:

Previous
From: Dave Cramer
Date:
Subject: Re: link to file bug against Postgres JDBC driver
Next
From: Dave Cramer
Date:
Subject: Re: Slow performance with 9.3-110x JDBC 4