X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 342549FB21A for ; Sun, 30 Apr 2006 20:37:32 -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 53091-03 for ; Sun, 30 Apr 2006 20:37:25 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id D51909FA682 for ; Sun, 30 Apr 2006 20:37:25 -0300 (ADT) Received: from mail1.ardec.com.au (unknown [203.11.83.254]) by svr4.postgresql.org (Postfix) with ESMTP id 9A49B5B2D1F for ; Sun, 30 Apr 2006 23:37:24 +0000 (GMT) Received: from [192.168.1.188] (lorax.bedrock.ardec.com.au [192.168.1.188]) by mail1.ardec.com.au (8.13.3/8.13.3) with ESMTP id k3UNb9Jn029261 for ; Mon, 1 May 2006 09:07:09 +0930 (CST) Message-ID: <44554A35.7060308@lisasoft.com> Date: Mon, 01 May 2006 09:07:25 +0930 From: Eric Lam User-Agent: Mozilla Thunderbird 1.0.7 (Windows/20050923) X-Accept-Language: en-us, en MIME-Version: 1.0 Cc: pgsql-performance@postgresql.org Subject: Re: Slow restoration question References: <444F24E9.2010907@lisasoft.com> <6110.1146342203@sss.pgh.pa.us> In-Reply-To: <6110.1146342203@sss.pgh.pa.us> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: ClamAV 0.88/1429/Sun Apr 30 20:00:14 2006 on mizaru.adl.ardec.com.au X-Virus-Status: Clean X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/72 X-Sequence-Number: 18859 Tom Lane wrote: >Eric Lam writes: > > >>what is the quickest way of dumping a DB and restoring it? I have done a >> >> > > > >> "pg_dump -D database | split --line-bytes 1546m part" >> >> > >Don't use "-D" if you want fast restore ... > > regards, tom lane > > > thanks, I read that from the doco, the reason why I am using the -D option is because I was informed by previous people in the company that they never got a 100% strike rate in database restoration without using the -D or -d options. If I have enough space on the QA/staging machine I'll give the no options dump restoration a try. Anyone have any estimates the time differences between the -D, -d and [using no option]. regards Eric Lam