I have just been noticing that pg_dump outputs index definitions sorted by index name (within a given schema). Would it not be better to sort by <indexed_relation_name, index_name> so that we get some benefit from caching the table when building multiple indexes on the same table?
cheers andrew ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
