Re: BUG #12779: pg_dump -Fd doesn't care about -Z

From: Christoph Berg <cb(at)df7cb(dot)de>
To: pgsql-bugs(at)postgresql(dot)org, Francisco Olarte <folarte(at)peoplecall(dot)com>
Subject: Re: BUG #12779: pg_dump -Fd doesn't care about -Z
Date: 2015-02-17 15:54:49
Message-ID: 20150217155449.GA21057@msg.df7cb.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Re: To pgsql-bugs(at)postgresql(dot)org 2015-02-17 <20150217153446(dot)2590(dot)24945(at)wrigleys(dot)postgresql(dot)org>
> 1164 1.fd
> 1164 9.fd
>
> 1488 1.fc
> 1160 9.fc

Re: Francisco Olarte 2015-02-17 <CA+bJJbza-+UOuofSVCoHdn6kMa3u4zWzgKZhyU=Qab46R4vY-w(at)mail(dot)gmail(dot)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(at)df7cb(dot)de | http://www.df7cb.de/

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Francisco Olarte 2015-02-17 16:15:43 Re: BUG #12779: pg_dump -Fd doesn't care about -Z
Previous Message Francisco Olarte 2015-02-17 15:50:34 Re: BUG #12779: pg_dump -Fd doesn't care about -Z