Re: BUG #1347: Bulk Import stopps after a while ( 8.0.0. - Mailing list pgsql-bugs

From Kris Jurka
Subject Re: BUG #1347: Bulk Import stopps after a while ( 8.0.0.
Date
Msg-id Pine.BSO.4.56.0412131704130.31457@leary.csoft.net
Whole thread Raw
Responses Re: [JDBC] BUG #1347: Bulk Import stopps after a while (
List pgsql-bugs
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@yahoo.com>
To: Kris Jurka <books@ejurka.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


pgsql-bugs by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: postgresql-8.0.0 beta5 & postgresql-7.4.6 can't compile successfully
Next
From: Tom Lane
Date:
Subject: Re: Error in pg_dump and pg_dumpall