Re: Slow performance with 9.3-110x JDBC 4

Поиск
Список
Период
Сортировка
От Dave Cramer
Тема Re: Slow performance with 9.3-110x JDBC 4
Дата
Msg-id CADK3HHKj_=03K+2L8yH+zyaw6zMWAFaafhuPf9V_Npf2fvTZAA@mail.gmail.com
обсуждение исходный текст
Ответ на Slow performance with 9.3-110x JDBC 4  (ChatPristi <cchristo_0899@yahoo.fr>)
Список pgsql-jdbc
Дерево обсуждения
Hi,
Prepared statements are handled much differently in the 9.3 drivers. They actually use server side prepared statements. 

The 8.4 driver just does selects or inserts, but does not plan a statement on the server

That being said in order to get to the root of your problem we would have to see exactly what your code is doing.
 

Dave Cramer


On Thu, Mar 27, 2014 at 9:35 AM, ChatPristi <cchristo_0899@yahoo.fr> wrote:
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.

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: ChatPristi
Дата:
Сообщение: Slow performance with 9.3-110x JDBC 4
Следующее
От: tim.lambrechts@laposte.net
Дата:
Сообщение: bug - connection problem with jdk 1.7 ?