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.
