Re: pg_restore and FK constraints with large dbs

pgSql 7.4.rc2

--- Peter Eisentraut <peter_e@gmx.net> wrote:
> If you you pg_dump and dump schema and data together, then there is some
> magic to temporarily disable foreign key constraints.  Try it out.

Dunno. Don't see any magic so far. In fact, pg_restore appears to use
internally the same SQL to verify that the validity of the FKs as "ALTER TABLE
xxx ADD CONSTRAINT". And it's not any faster either.

Is there a special option that one should specify to suspend FK checks during
pg_restore? Otherwise, pg_restore's performance is ... umm, not very good, to
put it mildly.

Thanks






__________________________________
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree