Postgres Pro
Downloads
Home   >   mailing lists

Re: Problem with copying data - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Problem with copying data
Date
Msg-id 20070409185914.GI10785@alvh.no-ip.org
Whole thread Raw
In response to Problem with copying data  (Klaas Dellschaft <klaasd@uni-koblenz.de>)
Responses Re: Problem with copying data  (Klaas Dellschaft <klaasd@uni-koblenz.de>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Raymond O'Donnell
Date:
Subject: Re: Can you combine text variable together to referenece a VIEW name ?
Next
From: "Dann Corbit"
Date:
Subject: Re: NEWBIE: How do I get the oldest date contained in 3 tables