Re: DB Dump Size

From: Tino Schwarze <postgresql(at)tisc(dot)de>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: DB Dump Size
Date: 2008-08-15 10:24:32
Message-ID: 20080815102432.GA10831@easy2.in-chemnitz.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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 Carol Walter 2008-08-15 13:44:56 Re: New postgres installation
Previous Message steve 2008-08-15 01:09:02 Re: DB Dump Size