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?
On Fri, 15 Aug 2008 12:24:32 +0200, Tino Schwarze <postgresql(at)tisc(dot)de>
> 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
>> That's not a great difference, but the size difference is quite
> 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...
> "What we nourish flourishes." - "Was wir nähren erblüht."
In response to
pgsql-admin by date
|Next:||From: Glyn Astill||Date: 2008-08-18 14:57:42|
|Subject: Re: DB Dump Size|
|Previous:||From: Devrim GÜNDÜZ||Date: 2008-08-16 13:59:31|
|Subject: Re: pgCluster and PostgreSQL|