Re: [GENERAL] Performance tuning using copy

2005-02-08 Thread Martijn van Oosterhout
On Tue, Feb 08, 2005 at 05:15:55AM -0800, sid tow wrote: > Hi, > > I have to know why does copy commands work faster as compared to > the insert commands. The thing is that i have a lot of > constraints and triggers. I know insert will check all the > triggers and constraints,

[GENERAL] Performance tuning using copy

2005-02-08 Thread sid tow
Hi,   I have to know why does copy commands work faster as compared to the insert commands. The thing is that i have a lot of constraints and triggers. I know insert will check all the triggers and constraints, but i wonder if copy will also do it and then if it does then this has also to be s