COPY will always be your best option if speed is the most important factor.
--Barry
Sam Varshavchik wrote:
>
> What would be the fastest way to insert a bunch of data (in 7.1)?
> Currently, a bunch of addBatch()es followed by executeBatch() is pretty
> fast, but not as fast as COPY TABLE via psql. I suppose I can use a
> single executeBatch() to insert the entire table, but AFAIK addBatch()
> just buffers the SQL in memory, and I prefer to have some kind of an
> upper limit on my memory footprint.
>