I'm watching a long, painfully slow 60GB load from pg_dump (8.1.2), and noticing it's jumping back and forth from different tables. I assume this is the index creation order showing up. 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
