Re: Why are pg_restore taking that long ? - Mailing list pgsql-general

From Poul Møller Hansen
Subject Re: Why are pg_restore taking that long ?
Date
Msg-id 4FBBAC91.4000507@pbnet.dk
Whole thread Raw
In response to Re: Why are pg_restore taking that long ?  (Josh Kupershmidt <schmiddy@gmail.com>)
List pgsql-general
 > 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



pgsql-general by date:

Previous
From: Ben Chobot
Date:
Subject: Re: why jasperserver has been changed from MySQL to PostGreSQL
Next
From: David Kerr
Date:
Subject: haproxy / pgpool / rhcs