From: Tino Schwarze <postgresql@tisc.de>
To: pgsql-admin@postgresql.org
Subject: Re: DB Dump Size
Date: Fri, 15 Aug 2008 12:24:32 +0200
Message-ID: <20080815102432.GA10831@easy2.in-chemnitz.de> (raw)
In-Reply-To: <e7a17e8b398d35d87c0b50ce9eae7b4d@127.0.0.1>
References: <326684d8c021f4afb82f8e921f9e0c40@127.0.0.1>
<20080814083003.GA456@internet24.de>
<02f4fac97d67bb4a1cee604724c8d62d@127.0.0.1>
<20080815001525.GA26208@internet24.de>
<e7a17e8b398d35d87c0b50ce9eae7b4d@127.0.0.1>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: postgresql@tisc.de
Subject: Re: DB Dump Size
In-Reply-To: <20080815102432.GA10831@easy2.in-chemnitz.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox