> Possibly. You should be able to tell what's taking so much time by
> keeping an eye on your server during the restore. You could set
> log_statement = 'all' (or just 'ddl' if there is significant other
> activity in other databases) during the restore, and keep an eye on
> pg_stat_activity if you need to.
>
OK, nothing unusual I think. It's the foreign keys that takes that long
to generate. I didn't realize that they are in the system tables.
Poul
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
