Re: [GENERAL] Problem with copying data

2007-04-10 Thread Klaas Dellschaft
Are there indexes or foreign keys in the tables? Check constraints? Other things we should know about? I think I found the problem. There were indexes on the tables which I wanted to copy. I remembered the performance tip to add indexes after copying the data when I saw the activity of my har

[GENERAL] Problem with copying data

2007-04-09 Thread Klaas Dellschaft
Hi, I'm currently trying to copy two large files (1.6 GB and 3.5 GB) with a "COPY FROM" into my database. But I'm waiting for the completion of this job since more than 24h. I'm working under Linux and with "top" I can see the two processes which should copy the data but most of the time they are

[GENERAL] Problem with copying data

2007-04-09 Thread Klaas Dellschaft
Hi, I'm currently trying to copy two large files (1.6 GB and 3.5 GB) with a "COPY FROM" into my database. But I'm waiting for the completion of this job since more than 24h. I'm working under Linux and with "top" I can see the two processes which should copy the data but most of the time they