Are there indexes or foreign keys in the tables? Check constraints?
Other things we should know about?
I think I found the problem. There were indexes on the tables which I
wanted to copy. I remembered the performance tip to add indexes after
copying the data when I saw the activity of my har
Alan Hodgson <[EMAIL PROTECTED]> writes:
> On Friday 06 April 2007 13:17, Klaas Dellschaft <[EMAIL PROTECTED]>
> wrote:
>> 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.
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
On Friday 06 April 2007 13:17, Klaas Dellschaft <[EMAIL PROTECTED]>
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"
