Re: Inserting a large number of records

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: Greg Alton <greg(at)cfdev(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Inserting a large number of records
Date: 2005-07-14 15:05:50
Message-ID: 42D67F4E.20204@opencloud.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Steve Wampler 2005-07-14 15:41:36 Re: Inserting a large number of records
Previous Message Greg Alton 2005-07-14 14:15:32 Inserting a large number of records