Postgres Pro
Downloads
Home   >   mailing lists

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

From Oliver Jowett
Subject Re: Inserting a large number of records
Date
Msg-id 42D67F4E.20204@opencloud.com
Whole thread Raw
In response to Inserting a large number of records  (Greg Alton <greg@cfdev.com>)
Responses Re: Inserting a large number of records  (Steve Wampler <swampler@noao.edu>)
List pgsql-jdbc
Tree view 
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.

-O

pgsql-jdbc by date:

Previous
From: Greg Alton
Date:
Subject: Inserting a large number of records
Next
From: Steve Wampler
Date:
Subject: Re: Inserting a large number of records