I have csv files that are sent to me on a regular basis. ~ 50k records a piece.
I have been simply using insert to date, but wonder if copy would give me better performance.
My questions are:
1) If I use copy, the docs suggest that I copy to a temp table then insert into mytable from temptable, in order for the sequence to fire.
Does the copy of 7.3 allow sequences to fire during copy?
2) The docs also suggest that I drop my indexes and reindex.
Would I need to do this if i copy to a temp table and insert? (would it make it that much faster?)
3) The idocs didnt seem to show much in the way of examples. Is there a better site?
The table to which I am inserting is currently >4M records and grow(n)ing.
Any suggestions would be appreciated
TIA
Chad