[Bizgres-general] Bizgres 0.9 Out Momentarily

Alon Goldshuv agoldshuv at greenplum.com
Mon Apr 3 16:25:50 GMT 2006


Hi Nick,

> 5. Enhancement: The beta PGBulkWriter has been added, this class uses
> the enhanced JDBC driver to bulk load PostgreSQL using the copy command,
> throughput is at least 2x that of a normal insert.

I have few questions about this one:

1 - Is it using a JDBC postgres COPY interface? If so, is it in an official
JDBC driver release or is it a patch to JDBC that implements access to COPY
(I seen one around in the last year or two).

2 - which options/enhancements does PGBulkWriter supply on top of the JDBC
driver?

I guess I could wait for the documentation, but I am very curious :-)

If this is a JDBC release feature, or something that you wrote that works
well we could integrate it in the java data loader potentially and remove
its jni/libpq layer. Any thoughts about it?

Regards,
Alon.




More information about the Bizgres-general mailing list