Postgres Pro
Downloads
Home   >   mailing lists

Re: Questions on pg_dump - Mailing list pgsql-admin

From Chris Hoover
Subject Re: Questions on pg_dump
Date
Msg-id 1d219a6f0807181358nca79789l2cc0bce9e3ab9a25@mail.gmail.com
Whole thread Raw
In response to Questions on pg_dump  ("Chris Hoover" <revoohc@gmail.com>)
List pgsql-admin
Tree view
We understand that.  The question is why is an uncompressed Fc format so much larger than a straight dump?  Is the so bad it takes almost 5% extra space?

On Fri, Jul 18, 2008 at 2:36 PM, Scott Mead <scottiebo@gmail.com> wrote:
Chris,

  Sorry I'm not responding to the list, I am not allowed to post from
my corporate account, and this account is not subscribed to the admin
list.

  -Z 0 means no compression.  You'll want to stick with the default
or -Z 9 for highest compression.

Hope this helps!

--Scott

pgsql-admin by date:

Previous
From: Rex Mabry
Date:
Subject: Re: Stop connections to a specific database
Next
From: "Aynur SANCAKLI"
Date:
Subject: Re: unrecognized data type on dblink