From: Dave Cramer <pg@fastcrypt.com>
To: Joshua D. Drake <jd@commandprompt.com>
Cc: Douglas J Hunley <doug@hunley.homeip.net>
Cc: pgsql-performance@postgresql.org
Subject: Re: 7 hrs for a pg_restore?
Date: Tue, 19 Feb 2008 13:15:10 -0500
Message-ID: <8FC570F6-C173-4327-8235-4CB8D64C9C4C@fastcrypt.com> (raw)
In-Reply-To: <20080219101254.754bd94d@commandprompt.com>
References: <200802191303.58840.doug@hunley.homeip.net>
<20080219101254.754bd94d@commandprompt.com>
On 19-Feb-08, at 1:12 PM, Joshua D. Drake wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> On Tue, 19 Feb 2008 13:03:58 -0500
> Douglas J Hunley <doug@hunley.homeip.net> wrote:
>
>> I spent a whopping seven hours restoring a database late Fri nite for
>> a client. We stopped the application, ran pg_dump -v -Ft -b -o $db >
>> ~/pre_8.3.tar on the 8.2.x db, and then upgrading the software to
>> 8.3. I then did a pg_restore -v -d $db ./pre_8.3.tar and watched it
>> positively crawl. I'll grant you that it's a 5.1G tar file, but 7
>> hours seems excessive.
>>
>> Is that kind of timeframe 'abnormal' or am I just impatient? :) If
>> the former, I can provide whatever you need, just ask for it.
>> Thanks!
>
> 7 hours for 5.1 G is excessive. It took me 11 hours to do 220G :). It
> would be helpful if we knew what the machine was doing. Was it IO
> bound? How much ram does it have? Is it just a single HD drive? What
> are your settings for postgresql?
>
Yeah, I did a 9G in about 20min. Did you optimize the new one ?
> Joshua D. Drake
>
>
> - --
> The PostgreSQL Company since 1997: http://www.commandprompt.com/
> PostgreSQL Community Conference: http://www.postgresqlconference.org/
> Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
> PostgreSQL SPI Liaison | SPI Director | PostgreSQL political pundit
>
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.6 (GNU/Linux)
>
> iD8DBQFHuxwoATb/zqfZUUQRAjNzAJ9FYBIdEpytIWHtvuqC2L0Phah9EwCfdGrZ
> kY1wItUqdtJ127ZA1Wl+95s=
> =vvm+
> -----END PGP SIGNATURE-----
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 7: You can help support the PostgreSQL project by donating at
>
> http://www.postgresql.org/about/donate
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: pg@fastcrypt.com, jd@commandprompt.com, doug@hunley.homeip.net
Subject: Re: 7 hrs for a pg_restore?
In-Reply-To: <8FC570F6-C173-4327-8235-4CB8D64C9C4C@fastcrypt.com>
References: <200802191303.58840.doug@hunley.homeip.net> <20080219101254.754bd94d@commandprompt.com> <8FC570F6-C173-4327-8235-4CB8D64C9C4C@fastcrypt.com>
* 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