Re: slow update of index during insert/copy

["Scott Carey" <scott@xxxxxxxxxxxxxxxxx>]

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.