Re: [BUGS] BUG #1347: Bulk Import stopps after a while ( - Mailing list pgsql-jdbc

From Oliver Jowett
Subject Re: [BUGS] BUG #1347: Bulk Import stopps after a while (
Date
Msg-id 41BE1CAF.5010406@opencloud.com
Whole thread Raw
In response to Re: [BUGS] BUG #1347: Bulk Import stopps after a while ( 8.0.0.  (Kris Jurka <books@ejurka.com>)
List 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

pgsql-jdbc by date:

Previous
From: Kris Jurka
Date:
Subject: Re: Interval type
Next
From: Kris Jurka
Date:
Subject: Re: Patch for jdbc escaped functions