pg_dump index/constraint creation order

From: "Ed L(dot)" <pgsql(at)bluepolka(dot)net>
To: Undisclosed(dot)Recipients: ;
Cc: pgsql-general(at)postgresql(dot)org
Subject: pg_dump index/constraint creation order
Date: 2006-05-14 04:27:26
Message-ID: 200605132227.27158.pgsql@bluepolka.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Markus Schiltknecht 2006-05-14 06:01:39 Re: rules: evaluate inputs in advance
Previous Message Kris Jurka 2006-05-14 00:15:08 Re: Mac Problem with Tunneling...