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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-admin by date

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