Re: Recommended technique for large imports?

Stephen Bacon writes:

> Now I know the COPY command is much faster because it doesn't update the
> indexes after every row insert, but building that and passing it via
> jdbc seems iffy (or C, PHP, etc. for that matter).

I think someone was working on a COPY implementation for jdbc, but I don't
think it's there yet.

> Can anyone give a recommended technique for this sort of process?

Feed a few thousand INSERTs to addBatch(), then call executeBatch().  That
seems to be the fastest way to import data, at this time.