"patrick keshishian" <pkeshish@gmail.com> writes:
> With these settings and running:
> pg_restore -vaOd dbname dbname.DUMP
If you had mentioned you were using random nondefault switches, we'd
have told you not to. -a in particular is a horrid idea performancewise
--- a standard schema-plus-data restore goes way faster because it's
doing index builds and foreign key checks wholesale instead of
incrementally.
> Is this because the -c option drops all foreign keys and
> so the restore goes faster? Should this be the preferred,
> recommended and documented method to run pg_restore?
It is documented in recent versions of the documentation: see
http://www.postgresql.org/docs/8.1/static/populate.html
particularly the last section.
regards, tom lane