From: | Edson Richter <edsonrichter(at)hotmail(dot)com> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: Slow performance with 9.3-110x JDBC 4 |
Date: | 2014-03-27 17:45:25 |
Message-ID: | BLU0-SMTP3032F9966CE1134E6757304CF670@phx.gbl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Em 27/03/2014 13:58, Lachezar Dobrev escreveu:
> 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.
>
What to expect from "protocolVersoin=2"?
Speed up or down?
Edson
--
*Edson Carlos Ericksson Richter*
/Sistemas para Bibliotecas, Escolinhas Infantis
Projetos sob medida para sua empresa/
Celular: (51) 9318-9766
(51) 8585-0796
/"A mente que se abre a uma nova ideia jamais voltará ao seu tamanho
original"/
- Albert Einstein
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Cramer | 2014-03-27 19:52:49 | Re: Slow performance with 9.3-110x JDBC 4 |
Previous Message | dmp | 2014-03-27 17:03:50 | Re: bug - connection problem with jdk 1.7 ? |