pg_dump index/constraint creation order - Mailing list pgsql-general

From Ed L.
Subject pg_dump index/constraint creation order
Date
Msg-id 200605132227.27158.pgsql@bluepolka.net
Whole thread Raw
Responses Re: pg_dump index/constraint creation order  (Vivek Khera <vivek@khera.org>)
List 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


pgsql-general by date:

Previous
From: Kris Jurka
Date:
Subject: Re: Mac Problem with Tunneling...
Next
From: Markus Schiltknecht
Date:
Subject: Re: rules: evaluate inputs in advance