Fastest method to insert data. - Mailing list pgsql-jdbc

From Sam Varshavchik
Subject Fastest method to insert data.
Date
Msg-id courier.3CC06C59.0000511D@ny.email-scan.com
Whole thread Raw
List pgsql-jdbc
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.


--
Sam


pgsql-jdbc by date:

Previous
From: "Marin Dimitrov"
Date:
Subject: Re: BLOB performance test FYI
Next
From: Barry Lind
Date:
Subject: Re: Fastest method to insert data.