Re: Inserting a large number of records - Mailing list pgsql-jdbc

Oliver Jowett wrote:
> Greg Alton wrote:
>
>>What is the most efficient way to insert a large number of records into
>>a table?
>
>
> I use a PreparedStatement INSERT and addBatch() / executeBatch() with
> autocommit off and no constraints or indexes present.

Does anyone have an idea as to how the performance of this would compare
to using a COPY?  I've used the COPY patches with jdbc and 7.4.x with
impressive results, but if the above is 'nearly' as good then I don't have
to put off upgrading to 8.x while waiting on jdbc to officially include
support for COPY.  (I can't test the above right now. Maybe soon, though.)

Thanks!
Steve
--
Steve Wampler -- swampler@noao.edu
The gods that smiled on your birth are now laughing out loud.