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.
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 |