Postgres Pro
Downloads
Home   >   mailing lists

Re: JDBC performance issue - Mailing list pgsql-general

From Dave Cramer
Subject Re: JDBC performance issue
Date
Msg-id CADK3HHK0ScZHy9BOifR_2W7Co+v4ij=4pYEac1MfOvgFQC1A5w@mail.gmail.com
Whole thread Raw
In response to JDBC performance issue  (CS DBA <cs_dba@consistentstate.com>)
List pgsql-general
Tree view
You said they upgraded the driver but the versions you stated are the same ???

Dave Cramer

dave.cramer(at)credativ(dot)ca
http://www.credativ.ca


On Wed, Feb 5, 2014 at 12:23 PM, CS DBA <cs_dba@consistentstate.com> 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?

Thanks in advance...





--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

pgsql-general by date:

Previous
From: Edson Richter
Date:
Subject: Re: Connection problems - local IP address refused!
Next
From: David Johnston
Date:
Subject: Re: JDBC performance issue