Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 9F28A9FB383 for ; Wed, 24 Jan 2007 20:24:58 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 13862-09 for ; Wed, 24 Jan 2007 20:24:56 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 16F589FB2B1 for ; Wed, 24 Jan 2007 20:24:55 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id l0P0OOlR012195; Wed, 24 Jan 2007 19:24:24 -0500 (EST) To: "Joshua D. Drake" cc: Colton A Smith , pgsql-admin@postgresql.org Subject: Re: pg_restore speed In-reply-to: <45B7E277.30108@commandprompt.com> References: <45B7E277.30108@commandprompt.com> Comments: In-reply-to "Joshua D. Drake" message dated "Wed, 24 Jan 2007 14:49:27 -0800" Date: Wed, 24 Jan 2007 19:24:24 -0500 Message-ID: <12194.1169684664@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/239 X-Sequence-Number: 24395 "Joshua D. Drake" writes: > Colton A Smith wrote: >> I have a 90G postgis-enabled postgresql >> database that I'm upgrading from 8.1.5 to >> 8.2.1. I initiated pg_restore nearly >> six days ago and it's still churning away, >> surely but slowly. Is this amount of >> time normal? Or have I done something >> wrong? > 6 days seems like an awful long time I could see 12-15 hours. What type > of machine do you have? What was the pg_dump command you used and > respective pg_restore? What is the restore actually doing at the moment? (Look in pg_stat_activity) For such a large DB I'd think you'd really need to increase shared_buffers, checkpoint_segments, and maintenance_work_mem well beyond their default values ... did you do that before starting to restore? (Actually I think you could probably do the latter two on-the-fly without disturbing the restore, so that might be something to try before giving up and starting over.) regards, tom lane