Skip site navigation (1) Skip section navigation (2)

Re: DB Dump Size

From: <steve(at)outtalimits(dot)com(dot)au>
To: Tino Schwarze <postgresql(at)tisc(dot)de>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: DB Dump Size
Date: 2008-08-18 01:35:00
Message-ID: 4b73e5d30df8b0e1a0939291a5a16c31@127.0.0.1 (view raw or flat)
Thread:
Lists: pgsql-admin
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 <postgresql(at)tisc(dot)de>
wrote:
> On Fri, Aug 15, 2008 at 11:09:02AM +1000, steve(at)outtalimits(dot)com(dot)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
> 
>

In response to

Responses

pgsql-admin by date

Next:From: Glyn AstillDate: 2008-08-18 14:57:42
Subject: Re: DB Dump Size
Previous:From: Devrim GÜNDÜZDate: 2008-08-16 13:59:31
Subject: Re: pgCluster and PostgreSQL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group