--- Peter EiEisentrautpeter_e@gmgmxet> 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
