Skip site navigation (1) Skip section navigation (2)

Re: 7 hrs for a pg_restore?

From: Dave Cramer <pg(at)fastcrypt(dot)com>
To: Joshua D(dot) Drake <jd(at)commandprompt(dot)com>
Cc: Douglas J Hunley <doug(at)hunley(dot)homeip(dot)net>, pgsql-performance(at)postgresql(dot)org
Subject: Re: 7 hrs for a pg_restore?
Date: 2008-02-19 18:15:10
Message-ID: 8FC570F6-C173-4327-8235-4CB8D64C9C4C@fastcrypt.com (view raw or flat)
Thread:
Lists: pgsql-performance
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(at)hunley(dot)homeip(dot)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


In response to

pgsql-performance by date

Next:From: Tom LaneDate: 2008-02-19 18:22:58
Subject: Re: 7 hrs for a pg_restore?
Previous:From: Richard HuxtonDate: 2008-02-19 18:13:37
Subject: Re: 7 hrs for a pg_restore?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group