Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 5116B6501C0 for ; Sun, 17 Aug 2008 22:35:10 -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 74079-04 for ; Sun, 17 Aug 2008 22:35:00 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from outbound.icp-qv1-irony-out1.iinet.net.au (outbound.icp-qv1-irony-out1.iinet.net.au [203.59.1.108]) by postgresql.org (Postfix) with ESMTP id C522F6501A8 for ; Sun, 17 Aug 2008 22:35:05 -0300 (ADT) X-IronPort-Anti-Spam-Filtered: true X-IronPort-Anti-Spam-Result: AgoFABtvqEh8q5Nq/2dsb2JhbACHeoNZhTOhWoFY X-IronPort-AV: E=Sophos;i="4.32,224,1217779200"; d="scan'208";a="370885311" Received: from unknown (HELO mail.outtalimits.com.au) ([124.171.147.106]) by outbound.icp-qv1-irony-out1.iinet.net.au with ESMTP; 18 Aug 2008 09:35:03 +0800 Received: from www.outtalimits.com.au (localhost [127.0.0.1]) by mail.outtalimits.com.au (Postfix) with ESMTP id D8E992B6405C; Mon, 18 Aug 2008 11:35:00 +1000 (EST) MIME-Version: 1.0 Date: Mon, 18 Aug 2008 11:35:00 +1000 From: To: Tino Schwarze Cc: pgsql-admin@postgresql.org Subject: Re: DB Dump Size In-Reply-To: <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> <20080815102432.GA10831@easy2.in-chemnitz.de> Message-ID: <4b73e5d30df8b0e1a0939291a5a16c31@127.0.0.1> X-Sender: steve@outtalimits.com.au User-Agent: RoundCube Webmail/0.2a Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200808/72 X-Sequence-Number: 29917 I am also curious as to why an SQL dump from the production server would come out to 2.8G but a dump of an exact replica on a test box would come out to 3.0G. What determines the size and makeup of an SQL dump? Cheers. Steve. On Fri, 15 Aug 2008 12:24:32 +0200, Tino Schwarze wrote: > 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 > >