From: | Dave Cramer <pg(at)fastcrypt(dot)com> |
---|---|
To: | Steve Wampler <swampler(at)noao(dot)edu> |
Cc: | Oliver Jowett <oliver(at)opencloud(dot)com>, pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: Inserting a large number of records |
Date: | 2005-07-15 11:47:42 |
Message-ID: | 6224A2D9-3B6F-4CFB-A69D-0CAB8DDBE94C@fastcrypt.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Here's a version ( a little old ) of the driver with copy implemented.
http://download.postgresintl.com/copy.tar.gz
Dave
On 14-Jul-05, at 11:41 AM, Steve Wampler wrote:
> 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.
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that
> your
> message can get through to the mailing list cleanly
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Cramer | 2005-07-15 13:05:06 | Re: Timezone conversion woes |
Previous Message | Oliver Jowett | 2005-07-15 08:33:35 | Re: Inserting a large number of records |