--- ow <[EMAIL PROTECTED]> wrote: > 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) FK constraint (80M table with FKs against 20K table with > PKs) > > 4.5 hours to check one FK constraint - this is what I meant by bad > performance. > I'm looking for a way to suspend FK checks since data is coming from pg_dump > and, hence, it's clean. >
No solution? Thanks __________________________________ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
