| From: | "Ed L(dot)" <pgsql(at)bluepolka(dot)net> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Cc: | Vivek Khera <vivek(at)khera(dot)org> |
| Subject: | Re: pg_dump index/constraint creation order |
| Date: | 2006-05-17 15:48:44 |
| Message-ID: | 200605170948.44870.pgsql@bluepolka.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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 the 8.1.2 pg_dump to make the dump from your 7.4.6
> DB, what is the order like?
> I suspect it would be more to what you're expecting. In
> general, you should use the pg_dump corresponding to the
> version into which you are loading for best results.
8.1.2 has same problem (try attached script to see).
Ed
| Attachment | Content-Type | Size |
|---|---|---|
| test.sh | application/x-shellscript | 641 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alban Hertroys | 2006-05-17 16:07:30 | Re: Age function |
| Previous Message | Dave Page | 2006-05-17 14:45:08 | Re: GUI Interface |