While watching a 9-hour 60GB network load from 7.4.6 pg_dump into 8.1.2, I noticed the order in which indices and constraints are created appears to be their creation order. Would it make more sense to have pg_dump dump indexes grouped by the table? That way, if a table got loaded into cache for one index creation, it might still be there for the immediatly following index creations on the same table...? Ed
