From: steve@outtalimits.com.au
To: Tino Schwarze <postgresql@tisc.de>
Cc: pgsql-admin@postgresql.org
Subject: Re: DB Dump Size
Date: Mon, 18 Aug 2008 11:35:00 +1000
Message-ID: <4b73e5d30df8b0e1a0939291a5a16c31@127.0.0.1> (raw)
In-Reply-To: <20080815102432.GA10831@easy2.in-chemnitz.de>
References: <326684d8c021f4afb82f8e921f9e0c40@127.0.0.1>
<20080814083003.GA456@internet24.de>
<02f4fac97d67bb4a1cee604724c8d62d@127.0.0.1>
<20080815001525.GA26208@internet24.de>
<e7a17e8b398d35d87c0b50ce9eae7b4d@127.0.0.1>
<20080815102432.GA10831@easy2.in-chemnitz.de>
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
>
>
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: steve@outtalimits.com.au, postgresql@tisc.de
Subject: Re: DB Dump Size
In-Reply-To: <4b73e5d30df8b0e1a0939291a5a16c31@127.0.0.1>
* 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