--- Peter [EMAIL PROTECTED]> wrote: > > Read again. No one was talking of pg_restore.
Perhaps I should clarify. First, I ran pg_dump to extract schema and data *together*. Then I ran pg_restore to restore the db. It took about 1 hour to create tables and copy the data, then about 40 min to create indexes, then pg_restore spent 4.5 hours checking one (1) FKFKonstraint (80M table with FKFKsgainst 20K table with PKPKs 4.5 hours to check one FKFKonstraint - this is want I meant by bad performance. I'm looking for a way to suspend FKFKhecks since data is coming from pg_dump and, hence, it's clean. Thanks __________________________________ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
