Re: pg_restore and FK constraints with large dbs - Mailing list pgsql-admin

--- ow <oneway_111@yahoo.com> 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