From: Iain <iain@mst.co.jp>
To: grupos@carvalhaes.net
Cc: pgsql-performance@postgresql.org
Subject: Re: pg_restore taking 4 hours!
Date: Tue, 14 Dec 2004 10:54:17 +0900
Message-ID: <00ee01c4e17f$d54f59a0$7201a8c0@mst1x5r347kymb> (raw)
References: <41ADA82A.7070405@carvalhaes.net>
<200412131025.54587.josh@agliodbs.com>
<83210A57-4D35-11D9-9C22-000A9578CFCC@kcilink.com>
<200412131043.28465.josh@agliodbs.com>
<27280.1102965664@sss.pgh.pa.us>
Hi,
Sorry, I didn't catch the original message, so I'm not sure if the original
poster mentioned the postgres version that he's using.
I just thought that I'd contribute this observation.
I have a DB that takes several hours to restore under 7,1 but completes in
around 10 minutes on 7.4. The main reason for this is that by default the
7.4 restore delays creation of PKs and indexes until after the data load,
whereas 7.1 doesn't.
I noticed that 7.1 has a re-arrange option that reportedly delays the pks
and indexes, so presumably this would have alleviated the problem.
I also noticed that a dumpfile created under 7.1 took hours to restore using
7.4 to load it as the order remained in the default of 7.1.
I don'tknow when the default behaviour changed, but I get the feeling it may
have been with 7.4.
HTH
Iain
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-performance@postgresql.org
Cc: iain@mst.co.jp, grupos@carvalhaes.net
Subject: Re: pg_restore taking 4 hours!
In-Reply-To: <00ee01c4e17f$d54f59a0$7201a8c0@mst1x5r347kymb>
References: <41ADA82A.7070405@carvalhaes.net> <200412131025.54587.josh@agliodbs.com> <83210A57-4D35-11D9-9C22-000A9578CFCC@kcilink.com> <200412131043.28465.josh@agliodbs.com> <27280.1102965664@sss.pgh.pa.us> <00ee01c4e17f$d54f59a0$7201a8c0@mst1x5r347kymb>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox