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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
