-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Tue, 19 Feb 2008 13:03:58 -0500 Douglas J Hunley <doug@xxxxxxxxxxxxxxxxx> 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? 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
