| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | Klaas Dellschaft <klaasd(at)uni-koblenz(dot)de> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Problem with copying data |
| Date: | 2007-04-09 18:59:14 |
| Message-ID: | 20070409185914.GI10785@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dann Corbit | 2007-04-09 19:05:25 | Re: NEWBIE: How do I get the oldest date contained in 3 tables |
| Previous Message | Raymond O'Donnell | 2007-04-09 18:56:25 | Re: Can you combine text variable together to referenece a VIEW name ? |