Re: [JDBC] BUG #1347: Bulk Import stopps after a while (

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: Kris Jurka <books(at)ejurka(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: [JDBC] BUG #1347: Bulk Import stopps after a while (
Date: 2004-12-13 22:50:23
Message-ID: 41BE1CAF.5010406@opencloud.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-jdbc

Kris Jurka wrote:
> I sent him a driver that was recompiled with MAX_BUFFERED_QUERIES = 1 and
> he still appears to be having some problems, but I have no idea where.

I wonder if he is doing one transaction per batch update loop or
something similar. If there's a bottleneck on the server side that's
related to the number of updates in a transaction (deferred constraints
or something similar?) then that could explain some of the behaviour.
Don't know why changing MAX_BUFFERED_QUERIES would change things at all
if that's the case, though.

-O

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2004-12-14 02:23:58 Re: Error in pg_dump and pg_dumpall
Previous Message Kris Jurka 2004-12-13 22:06:00 Re: BUG #1347: Bulk Import stopps after a while ( 8.0.0.

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kris Jurka 2004-12-14 06:35:53 Re: Patch for jdbc escaped functions
Previous Message Kris Jurka 2004-12-13 22:13:10 Re: Interval type