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
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@yahoo.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
From:
Venkateswar Reddy Melachervu Date: Subject:
Inputs Appreciated - Calling pgsql stored proc with user defined sql
types from java using pgsql-jdbc
Есть вопросы? Напишите нам!
Соглашаюсь с условиями обработки персональных данных
✖
By continuing to browse this website, you agree to the use of cookies. Go to Privacy Policy.