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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
