Обсуждение: JDBC performance issue

Hi All;

We have a client running Pentaho to migrate data.

They recently upgraded Pentaho which upgraded their JDBC driver from 8.4
(postgresql-8.4-703.jdbc4.jar) to 9.1 (postgresql-8.4-703.jdbc4.jar).
They have a test set which updates 1000 rows, with the old driver it
takes about 30 seconds, but the new driver takes 3x longer.

This is on PostgreSQL 9.1

Thoughts?

Thanks in advance...

CS DBA wrote
> Hi All;
>
> We have a client running Pentaho to migrate data.
>
> They recently upgraded Pentaho which upgraded their JDBC driver from 8.4
> (postgresql-8.4-703.jdbc4.jar) to 9.1 (postgresql-8.4-703.jdbc4.jar).
> They have a test set which updates 1000 rows, with the old driver it
> takes about 30 seconds, but the new driver takes 3x longer.
>
> This is on PostgreSQL 9.1
>
> Thoughts?

Good News!  This seems to be a re-producible problem.

Bad News!  Either you/your client will need to discover the bottle-neck or
you will need to provide the test set/routine to the public so someone else
can try.

Also, maybe run the test set against and with 9.2 and/or 9.3 to see if the
problem still exists there...

Note, I presume you mean "updates 1000s of rows" (i.e., considerably more
than 1,000) - 30s to update exactly 1000 rows doesn't seem that impressive
but then again no clue what is involved so maybe that is good.  Note that
means it is unclear if the "UPDATE" phase or some required "SELECT" is
mis-behaving which is a critical detail.

David J.




--
View this message in context: http://postgresql.1045698.n5.nabble.com/JDBC-performance-issue-tp5790710p5790714.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.