Re: Problem with copying data - Mailing list pgsql-general

From Klaas Dellschaft
Subject Re: Problem with copying data
Date
Msg-id 461B3DD2.1040101@uni-koblenz.de
Whole thread Raw
In response to Re: Problem with copying data  (Alvaro Herrera <alvherre@commandprompt.com>)
List 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

pgsql-general by date:

Previous
From: Robert Treat
Date:
Subject: Re: Pg schema diff tools Was: [ANNOUNCE] == PostgreSQL Weekly News - April 08 2007 ==
Next
From: Dave Page
Date:
Subject: Re: programmatic way to fetch latest release for a given major.minor version