Re: jdbc batch performance problem

> If as you say it do not exist any diference I think it will be
> possible to improve executeBatch.
> For example for it's implementation to use the pg copy command.
> Exist at the moment any work for improving the batch commands?
>

To use COPY instead of insert during executeBatch would require some
complicated parsing of the statement to determine if it was really a
simple insert that could be translated into COPY. If your statement had a
function call or a subselect it could not use COPY. Also I'm not sure
what translating an INSERT into a COPY would do if you we're inserting
into a table that had rules on it.

There was a patch around that provided an API to use COPY explicitly which
might suit your needs.

Kris Jurka