Weird pause when running statements

From: Grant Quimby <grant_quimby(at)dialog(dot)com(dot)au>
To: "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Weird pause when running statements
Date: 2008-08-06 00:56:38
Message-ID: 1816F2D2ACB8AB469D3FFA6819ADC23B154A8F720C@bnemxbox01.dialoggroup.internal
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi,

I've done some research and this appears to be a unique problem.

During an ETL process using the 8.3-603 JDBC3 driver with Pentaho Data Integration the transactions and everything stops processing. No disk access, No process activity, Nothing. The Postgres processes are still present.

After reloading the server configuration the processes just start off where they stopped and continue normally. Sometimes they stop again, the same workaround sets the process running again. However trying to deploy this process to a server means that those pauses are unacceptable. This appears to be a problem with the driver and/or the server. Anybody have any suggestions? I'd rather not have to port everything to another DBMS.

Thanks in advance.

Regards,

Grant Quimby
Consultant
Dialog Information Technology
Ph: +61 2 6209 2600
Fx: +61 2 6209 2602
grant_quimby(at)dialog(dot)com(dot)au

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Oliver Jowett 2008-08-06 01:07:10 Re: Weird pause when running statements
Previous Message Daniele Depetrini 2008-08-05 17:12:50 Pooled connections idle timeout