Sunday, August 17, 2008

Re: [ADMIN] DB Dump Size

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@tisc.de>
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
>
>

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

No comments: