From: | Lachezar Dobrev <l(dot)dobrev(at)gmail(dot)com> |
---|---|
To: | ChatPristi <cchristo_0899(at)yahoo(dot)fr> |
Cc: | "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: Slow performance with 9.3-110x JDBC 4 |
Date: | 2014-03-27 16:58:23 |
Message-ID: | CA+xsaB0N_9z3ghhHQ8xC09kbF6xvrpj8BJa7tUvHFbBg7xFDgQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
You might want to do the same tests after adding ?protocolVersion=2
to the connection URL.
i.e.:
jdbc:postgresql://localhost/database?protocolVersion=2
2014-03-27 15:35 GMT+02:00 ChatPristi <cchristo_0899(at)yahoo(dot)fr>:
> 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 | dmp | 2014-03-27 17:03:50 | Re: bug - connection problem with jdk 1.7 ? |
Previous Message | Dave Cramer | 2014-03-27 14:57:50 | Re: bug - connection problem with jdk 1.7 ? |