Skip site navigation (1) Skip section navigation (2)

Re: BUG #1347: Bulk Import stopps after a while ( 8.0.0.

From: Kris Jurka <books(at)ejurka(dot)com>
To: pgsql-bugs(at)postgresql(dot)org, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: BUG #1347: Bulk Import stopps after a while ( 8.0.0.
Date: 2004-12-13 22:06:00
Message-ID: Pine.BSO.4.56.0412131704130.31457@leary.csoft.net (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-jdbc
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.

Kris Jurka

---------- Forwarded message ----------
Date: Mon, 13 Dec 2004 06:51:10 -0800 (PST)
From: Bahadur Singh <bahadursingh(at)yahoo(dot)com>
To: Kris Jurka <books(at)ejurka(dot)com>
Subject: Re: [BUGS] BUG #1347: Bulk Import  stopps after a while ( 8.0.0.
    RC1)

Thanks for your efforts.
It works but not fully:

Batch Size == Result (with last compilation from
you..)

1000 == Works, a before quite fast..
2000 == Works,   -- do--
5000 == Works fine.. little slow (before it was not
working always..)

10,000 == Sometime worked (more slower.. before it was
not working .. )
20,000 == Did not worked ..

But, somehow I am convinced that this is JDBC driver
problem, so I can change this setting to optimal. I
was  worried as if would not have been DB server
problem.

Many Thanks for your help !

With Best Regards
Bahadur


Responses

pgsql-bugs by date

Next:From: Oliver JowettDate: 2004-12-13 22:50:23
Subject: Re: [JDBC] BUG #1347: Bulk Import stopps after a while (
Previous:From: Oliver JowettDate: 2004-12-13 21:13:57
Subject: Re: [JDBC] BUG #1347: Bulk Import stopps after a while (

pgsql-jdbc by date

Next:From: Kris JurkaDate: 2004-12-13 22:13:10
Subject: Re: Interval type
Previous:From: Oliver JowettDate: 2004-12-13 21:13:57
Subject: Re: [JDBC] BUG #1347: Bulk Import stopps after a while (

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group