Problem with copying data

From: Klaas Dellschaft <klaasd(at)uni-koblenz(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Problem with copying data
Date: 2007-04-07 11:18:40
Message-ID: 46177E10.5000500@uni-koblenz.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-general by date

  From Date Subject
Next Message Marcus Engene 2007-04-07 11:49:38 Re: performance; disk bad or something?
Previous Message Martijn van Oosterhout 2007-04-07 11:13:41 Re: New to concurrency