Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id B188E2E0040 for ; Tue, 19 Feb 2008 14:15:39 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 17231-02-2 for ; Tue, 19 Feb 2008 14:15:21 -0400 (AST) Received: from beaver.fastcrypt.com (beaver.fastcrypt.com [64.7.141.17]) by postgresql.org (Postfix) with ESMTP id 92F962E0052 for ; Tue, 19 Feb 2008 14:15:13 -0400 (AST) Received: from [192.168.1.14] (dcdsl.ebox.com [64.7.143.116]) by beaver.fastcrypt.com (Postfix) with ESMTP id A2A771580368; Tue, 19 Feb 2008 13:18:25 -0500 (EST) Cc: Douglas J Hunley , pgsql-performance@postgresql.org Message-Id: <8FC570F6-C173-4327-8235-4CB8D64C9C4C@fastcrypt.com> From: Dave Cramer To: Joshua D. Drake In-Reply-To: <20080219101254.754bd94d@commandprompt.com> Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes Content-Transfer-Encoding: 7bit Mime-Version: 1.0 (Apple Message framework v919.2) Subject: Re: 7 hrs for a pg_restore? Date: Tue, 19 Feb 2008 13:15:10 -0500 References: <200802191303.58840.doug@hunley.homeip.net> <20080219101254.754bd94d@commandprompt.com> X-Mailer: Apple Mail (2.919.2) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/215 X-Sequence-Number: 28757 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 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