| 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
| 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 |