Re: Slow performance with 9.3-110x JDBC 4

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(at)yahoo(dot)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.
>