Re: pg_dump -Fd and compression level

On 07/24/2015 02:52 AM, Marc Mamin wrote:
> Hello,
>
> After our last upgrade, we've noticed a 10-20% size increase of our dump size.
> This comes from our backup scripts were pg_dump was called without setting -Z
>
> So it seems, that this fix did modify the default compression to use:
> http://michael.otacoo.com/postgresql-2/pg_dump-directory-format-compression/
>
> not sure if this is expected or if this commit accidently changed the default compression, setting it too low.
>
> moreover, the doc is somewhat unclear here as it mentions all formats but the directory one:
>
> -Z 0..9
> --compress=0..9
>
> Specify the compression level to use. Zero means no compression.
> For the custom archive format, this specifies compression of individual
> table-data segments, and the default is to compress at a moderate level.
> For plain text output, setting a nonzero compression level causes the entire
> output file to be compressed, as though it had been fed through gzip;
> but the default is not to compress.
> The tar archive format currently does not support compression at all.
>
> shouldn't that be changed to
>
> - For the custom archive format
> + For the directory and custom archive formats
>
>

What did you upgrade from/to?

cheers

andrew