From: | Steve Wampler <swampler(at)noao(dot)edu> |
---|---|
To: | Oliver Jowett <oliver(at)opencloud(dot)com> |
Cc: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: Inserting a large number of records |
Date: | 2005-07-14 15:41:36 |
Message-ID: | 42D687B0.6040009@noao.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Oliver Jowett wrote:
> 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.
Does anyone have an idea as to how the performance of this would compare
to using a COPY? I've used the COPY patches with jdbc and 7.4.x with
impressive results, but if the above is 'nearly' as good then I don't have
to put off upgrading to 8.x while waiting on jdbc to officially include
support for COPY. (I can't test the above right now. Maybe soon, though.)
Thanks!
Steve
--
Steve Wampler -- swampler(at)noao(dot)edu
The gods that smiled on your birth are now laughing out loud.
From | Date | Subject | |
---|---|---|---|
Next Message | Csaba Nagy | 2005-07-14 16:23:33 | Using a 7_4 JDBC driver to connect to 8.0 |
Previous Message | Oliver Jowett | 2005-07-14 15:05:50 | Re: Inserting a large number of records |