Klaas Dellschaft wrote: > 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 not working. Very seldom they are using some CPU time and then > get idle again. Are there indexes or foreign keys in the tables? Check constraints? Other things we should know about? -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support
