> 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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general