Fastest method to insert data.

From: Sam Varshavchik <mrsam(at)courier-mta(dot)com>
To: "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Fastest method to insert data.
Date: 2002-04-19 19:13:29
Message-ID: courier.3CC06C59.0000511D@ny.email-scan.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Alexander Troppmann 2002-04-19 19:39:22 Troubles using PreparedStatements
Previous Message Marin Dimitrov 2002-04-19 18:40:58 Re: BLOB performance test FYI