Re: Problem with copying data

From: Klaas Dellschaft <klaasd(at)uni-koblenz(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Problem with copying data
Date: 2007-04-10 07:33:38
Message-ID: 461B3DD2.1040101@uni-koblenz.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> 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 hard drive during
importing the data on my local computer. This feedback of the hard drive
LED was missing during the import on the server ;-)

Thanks,
Klaas

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dave Page 2007-04-10 07:36:10 Re: programmatic way to fetch latest release for a given major.minor version
Previous Message Leon Mergen 2007-04-10 06:46:41 INSERT..RETURNING on a partitioned table