Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id BE5CE9FB5D3 for ; Thu, 22 Feb 2007 12:14:01 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 14686-03 for ; Thu, 22 Feb 2007 12:13:46 -0400 (AST) X-Greylist: delayed 00:15:10.524065 by SQLgrey-1.7.4 Received: from eciweb.eldocomp.com (eciweb.eldocomp.com [205.159.99.39]) by postgresql.org (Postfix) with ESMTP id BBE329FB490 for ; Thu, 22 Feb 2007 12:13:46 -0400 (AST) Received: from ecimail.eldocomp.com [172.20.128.2] by eciweb.eldocomp.com with XWall v3.38 ; Thu, 22 Feb 2007 08:58:31 -0700 Received: from ecimail.eldocomp.com ([172.20.128.2]) by ecimail.eldocomp.com with Microsoft SMTPSVC(6.0.3790.1830); Thu, 22 Feb 2007 08:58:31 -0700 Received: from [172.20.131.10] ([172.20.131.10]) by ecimail.eldocomp.com with Microsoft SMTPSVC(6.0.3790.1830); Thu, 22 Feb 2007 08:58:31 -0700 References: <821429.69798.qm@web50304.mail.yahoo.com> In-Reply-To: <821429.69798.qm@web50304.mail.yahoo.com> From: Naomi Walker To: "ogjunk-pgjedan@yahoo.com" Cc: "pgsql-admin@postgresql.org" Subject: Re: Fastest DB restore options Date: Thu, 22 Feb 2007 08:58:31 -0700 X-Assembled-By: XWall v3.38 Message-ID: <45DDBDA7.50705@eldocomp.com> Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=BAYES_50 X-Spam-Level: X-Archive-Number: 200702/290 X-Sequence-Number: 24755 Consider leaving all indicies off until the load finishes... Naomi ogjunk-pgjedan@yahoo.com wrote: > Hello, > > I have a fairly large DB to dump and restore as fast as possible. I'm mov= ing from 8.0.3 to 8.2.3! :) > > I normally dump with these options: > > -d MyDB --clean --inserts --column-inserts --format=3DP > > But the last time I tried that, the restore took foreeeeeeeeeeeeeever. So= I'm looking for the fastest way to import data from the old DB to the new o= ne. Judging from pg_dump man page the following should be the fastest dump = & restore: > > -d MyDB --format=3Dc --ignore-version > =20 > Is there anything else I can do to make the restore as fast as possible? > > Thanks, > Otis > > . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . > Simpy -- http://www.simpy.com/ - Tag - Search - Share > > > > ---------------------------(end of broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match > =20 --=20 ----------------------------------------------------------------------------= =20 Naomi Walker Chief Information Officer=20 Mphasis Healthcare Solutions nwalker@mhs.mphasis.com=20 =20 ---An EDS Company 602-604-3100=20 ----------------------------------------------------------------------------= =20 A positive attitude may not solve all your problems, but it will annoy=20 enough people to make it worth the effort. --Herm Albright (1876 - 1944) ---------------------------------------------------------------------------- -- CONFIDENTIALITY NOTICE -- Information transmitted by this=C2=A0e-mail is proprietary to MphasiS and/or= its Customers and is intended for use only by the individual or entity to w= hich it is addressed, and may contain information that is=C2=A0privileged, c= onfidential or exempt from disclosure under applicable law. If you are not t= he intended recipient or it appears that this e-mail has been forwarded to y= ou without proper authority, you are notified that any use or dissemination = of this information in any manner is strictly prohibited. In such cases, ple= ase notify us immediately at mailmaster@mphasis.com and delete this mail fro= m your records.