On Tue, 5 Feb 2008, Arie Ozarov wrote:
> I understand that JDBC has some overhead (object translation,..) but didn't
> think the difference would be that big. Do this numbers look correct (any
> optimization suggestion?)
The real cost is the protocol level overhead of INSERT vs COPY. JDBC
batch execution groups things together to reduce the number of network
round trips, but it still has to send each insert as an individual request
to the server.
> Any performance improvement in postgresql-8.2-507.jdbc4.jar?
>
No.
> Is the copy operation much more optimized than inserts (and if so when/will
> the driver support it)?
>
Yes, copy is significantly faster than insert. If you'd like, construct a
psql test case that does 100,000 individual inserts and you'll see it's
not just a JDBC driver/libpq difference.
Copy support is available using this patched driver, but it has not been
integrated into the official version yet.
http://kato.iki.fi/sw/db/postgresql/jdbc/copy/
Kris Jurka