Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 4E56B650293 for ; Fri, 15 Aug 2008 07:24:40 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 93076-03 for ; Fri, 15 Aug 2008 07:24:30 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from easy2.in-chemnitz.de (easy2.in-chemnitz.de [88.198.17.232]) by postgresql.org (Postfix) with ESMTP id A1D6E650292 for ; Fri, 15 Aug 2008 07:24:34 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by easy2.in-chemnitz.de (Postfix) with ESMTP id 46C9747000D for ; Fri, 15 Aug 2008 12:24:32 +0200 (CEST) Received: from easy2.in-chemnitz.de ([127.0.0.1]) by localhost (easy.in-chemnitz.de [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id PzosP+a2ssEC for ; Fri, 15 Aug 2008 12:24:32 +0200 (CEST) Received: by easy2.in-chemnitz.de (Postfix, from userid 1013) id 347F9470009; Fri, 15 Aug 2008 12:24:32 +0200 (CEST) Date: Fri, 15 Aug 2008 12:24:32 +0200 From: Tino Schwarze To: pgsql-admin@postgresql.org Subject: Re: DB Dump Size Message-ID: <20080815102432.GA10831@easy2.in-chemnitz.de> References: <326684d8c021f4afb82f8e921f9e0c40@127.0.0.1> <20080814083003.GA456@internet24.de> <02f4fac97d67bb4a1cee604724c8d62d@127.0.0.1> <20080815001525.GA26208@internet24.de> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: User-Agent: Mutt/1.5.13 (2006-08-11) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200808/62 X-Sequence-Number: 29907 On Fri, Aug 15, 2008 at 11:09:02AM +1000, steve@outtalimits.com.au wrote: > Nice, that has cleared it up. > > I am on 8.1 also. > > On my test box, a standard dump took 6m 26sec & a -Fc dump took 11min 2sec. > That's not a great difference, but the size difference is quite noticeable. You might use --compress=6 or even --compress=1 to lower the impact of compression and try again. On the other hand, 11 minutes is not a big deal for dumping a whole DB... Tino. -- "What we nourish flourishes." - "Was wir nähren erblüht." www.craniosacralzentrum.de www.forteego.de