Re: Fastest method to insert data.

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.
>