X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 426C79F9F8F for ; Wed, 24 May 2006 08:37:54 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 62028-03 for ; Wed, 24 May 2006 08:37:48 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from vsx-kg01.ocn.ad.jp (vsx-kg01.ocn.ad.jp [211.129.13.49]) by postgresql.org (Postfix) with ESMTP id 79C969FA2DB for ; Wed, 24 May 2006 08:37:48 -0300 (ADT) Received: from sgc002.ocn.ne.jp (mv-kg003.ocn.ad.jp [211.6.83.126]) by vsx-kg01.ocn.ad.jp (Postfix) with SMTP id CE8702E0B for ; Wed, 24 May 2006 20:37:45 +0900 (JST) Received: from D5T7W62J (dsl-51-161.dsl.netsource.ie [213.79.51.161]) by sgc002.ocn.ne.jp (Postfix) with SMTP id 0BD1910E1 for ; Wed, 24 May 2006 20:37:44 +0900 (JST) Message-ID: <008c01c67f26$9848caf0$2815a8c0@D5T7W62J> From: "Ruairi" To: Subject: Restore of pg_dump taking a long time... Date: Wed, 24 May 2006 12:38:33 +0100 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2869 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.698 tagged_above=0 required=5 tests=AWL, BAYES_00, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200605/335 X-Sequence-Number: 21867 Hi, I'm currently restoring a fairly large DB from a pg_dump and it's taking about 12 hours to finish. The main part of this time is spent creating indexes. Is there anyway I can speed up the restore process, or do i just have to wait? I'm using postgres 8.1.3 on freebsd and the pg_dump is gzip'd. I'm restoring with the following command : "zcat | psql -U postgres " Regards, Ruairi Carroll