Re: [PERFORM] slow update of index during insert/copy

[Scott Carey]

>
>
>
>  On the performance impact of using COPY instead of INSERT :  out of
>> curiosity, were you comparing COPY against raw row-by-row inserts (slow) or
>> JDBC batch inserts (faster) or multi-row inserts: INSERT into X (a,b,c)
>> values (1,2,3) , (4,5,6) , (7,8,9 ) , (10,11,12)  .... ?
>>
>
> I tested row by row and jdbc batch, but I dont have the measured numbers
> any more. But I suppose I could recreate the test if, need be.
>
> regards
> thomas
>
>
> Don't re-create it, I was just curious.