Re: [GENERAL] pg_dump index/constraint creation order

2006-05-17 Thread Ed L.
On Monday May 15 2006 11:14 am, Vivek Khera wrote: > On May 14, 2006, at 12:27 AM, Ed L. wrote: > > 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. > > If you use th

Re: [GENERAL] pg_dump index/constraint creation order

2006-05-15 Thread Vivek Khera
On May 14, 2006, at 12:27 AM, Ed L. wrote: 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. If you use the 8.1.2 pg_dump to make the dump from your 7.4.6 DB, what is

[GENERAL] pg_dump index/constraint creation order

2006-05-13 Thread Ed L.
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 f