Re: jdbc batch performance problem

Currently there is no difference between inserts done serially or done 
via the batch interface.  In both cases there is one round trip per 
insert.  This is an area of the code that would welcome contributions.

--Barry

pginfo wrote:
> Hi,
> 
> I am using pg + jdbc for j2ee development from a long time.
> The main problem I found is the very bad insert performance.
> I am using addBatch and executeBatch for minimum network trafik,
> but it is also very slow.
> For example if I try to insert 1000 rows ( in one transaction) into very
> simple table
> it takes ~ 3000 ms. If i use insert into myTable select ... it takes
> only 10 ms.
> 
> Exist any basic performance problem for pg jdbc or I make mistake?
> Also I testet the same example on oracle 8i and mysql.
> It is working much much better.
> I love pg but it will be great if I can make insert faster.
> 
> Many thanks,
> ivan.
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>