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
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. |
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 |