From: | Lachezar Dobrev <l(dot)dobrev(at)gmail(dot)com> |
---|---|
To: | Dave Cramer <davecramer(at)gmail(dot)com> |
Cc: | Edson Richter <edsonrichter(at)hotmail(dot)com>, List <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: Slow performance with 9.3-110x JDBC 4 |
Date: | 2014-03-28 09:49:56 |
Message-ID: | CA+xsaB0+FTnzVf+Sn_pqVq=OjDDzgh81pHzt8R8SJaCiqPMFLg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
For the record: I was recommending that for testing purposes only, to
check if the reduced performance is related to protocol version (I believe
there is a significant change it might).
2014-03-27 21:52 GMT+02:00 Dave Cramer <davecramer(at)gmail(dot)com>:
> I wanted to avoid that recommendation, but since it is out there.
> protocolVersion reverts to the same protocol as 8.4 uses which does not use
> server side prepared statements
>
> And I would expect it to speed up, or at least be the same as 8.4.7
>
> Dave
>
> www.credativ.ca
>
>
> On Thu, Mar 27, 2014 at 1:45 PM, Edson Richter <edsonrichter(at)hotmail(dot)com>wrote:
>
>> 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> <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 | ChatPristi | 2014-03-28 10:25:43 | Re: Slow performance with 9.3-110x JDBC 4 |
Previous Message | Venkateswar Reddy Melachervu | 2014-03-28 09:24:37 | Re: Re: Inputs Appreciated - Calling pgsql stored proc with user defined sql types from java using pgsql-jdbc |