Problem with copying data - Mailing list pgsql-general

From Klaas Dellschaft
Subject Problem with copying data
Date
Msg-id 4616AAD7.6050100@uni-koblenz.de
Whole thread Raw
Responses Re: Problem with copying data  (Alan Hodgson <ahodgson@simkin.ca>)
Re: Problem with copying data  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-general
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.

I already tried restarting the Postgres server and I also restarted
Linux but nothing seems to work. Do you have any hints how I can find
out what's going on there and why the two processes are idle most of the
time?

Thanks,
Klaas

pgsql-general by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: backend reset of database
Next
From: "Danny E. Armstrong"
Date:
Subject: Re: YTA Time Zone Question