Re: BUG #12779: pg_dump -Fd doesn't care about -Z - Mailing list pgsql-bugs

From Christoph Berg
Subject Re: BUG #12779: pg_dump -Fd doesn't care about -Z
Date
Msg-id 20150217155449.GA21057@msg.df7cb.de
Whole thread Raw
In response to BUG #12779: pg_dump -Fd doesn't care about -Z  (christoph.berg@credativ.de)
Responses Re: BUG #12779: pg_dump -Fd doesn't care about -Z  (Francisco Olarte <folarte@peoplecall.com>)
List pgsql-bugs
Re: To pgsql-bugs@postgresql.org 2015-02-17 <20150217153446.2590.24945@wrigleys.postgresql.org>
> 1164    1.fd
> 1164    9.fd
>
> 1488    1.fc
> 1160    9.fc

Re: Francisco Olarte 2015-02-17 <CA+bJJbza-+UOuofSVCoHdn6kMa3u4zWzgKZhyU=Qab46R4vY-w@mail.gmail.com>
> > pg_dump -Fd doesn't seem to care about -Z for Z > 0:
> >
>
> With such a small dump, are you sure du's block granularity is not masking
> the differences in -Fd ? ( Have you tried  du -b, or just comparing every
> size ?) ( In -Fc it is a single file, harder to mask ).

I noticed when trying to compress an assumed-to-be-Z4 file a bit more
using -Z7. The directory was 241GB in both cases.

And if you compare with -Fc, the difference is a lot more than a few
FS blocks.

Christoph
--
cb@df7cb.de | http://www.df7cb.de/

pgsql-bugs by date:

Previous
From: Francisco Olarte
Date:
Subject: Re: BUG #12779: pg_dump -Fd doesn't care about -Z
Next
From: Francisco Olarte
Date:
Subject: Re: BUG #12779: pg_dump -Fd doesn't care about -Z