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 по дате отправления: