Slow performance with 9.3-110x JDBC 4

Поиск
Список
Период
Сортировка
От ChatPristi
Тема Slow performance with 9.3-110x JDBC 4
Дата
Msg-id 1395927334.64921.YahooMailNeo@web28904.mail.ir2.yahoo.com
обсуждение исходный текст
Ответы Re: Slow performance with 9.3-110x JDBC 4
Re: Slow performance with 9.3-110x JDBC 4
Список pgsql-jdbc
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 по дате отправления:

Предыдущее
От: Dave Cramer
Дата:
Сообщение: Re: link to file bug against Postgres JDBC driver
Следующее
От: Dave Cramer
Дата:
Сообщение: Re: Slow performance with 9.3-110x JDBC 4