MIME-Version: 1.0
References: 
 <CANzqJaAiTvMbuTUX86vZVCUY62KyHPffd_Dt1Po6Jmqv_9A_Bg@mail.gmail.com>
 <e31d0f6daaef9a7ce7248f43bd1063d444b4e859.camel@cybertec.at>
 <6bff91db-843e-4858-95dd-cc8bfb90c012@jakobs.com>
In-Reply-To: <6bff91db-843e-4858-95dd-cc8bfb90c012@jakobs.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Tue, 3 Feb 2026 03:13:37 -0500
Message-ID: 
 <CANzqJaA=e+OgRHtD_W2Ht6ZOu+GY+FZHfLtKWOrGqgkmvVMCpA@mail.gmail.com>
Subject: Re: Does pg_dump custom format only compress the table data?
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000e274290649e704ee"
Archived-At: 
 <https://www.postgresql.org/message-id/CANzqJaA%3De%2BOgRHtD_W2Ht6ZOu%2BGY%2BFZHfLtKWOrGqgkmvVMCpA%40mail.gmail.com>
Precedence: bulk

--000000000000e274290649e704ee
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Tue, Feb 3, 2026 at 2:51=E2=80=AFAM Holger Jakobs <holger@jakobs.com> wr=
ote:

> Am 03.02.26 um 07:06 schrieb Laurenz Albe:
> > On Mon, 2026-02-02 at 10:55 -0500, Ron Johnson wrote:
> >> Out of curiosity, I opened that dump file in vim, and saw not only DDL
> strings but cleartext table data.
> >>
> >> Why isn't it compressed?
> > Are your DDL statement large enough that you would expect that
> compressing
> > them would offer any real advantage?
> >
> > Yours,
> > Laurenz Albe
>
> That wasn't the question. It was about why table DATA aren't compressed,
> but in clear text.
>

Exactly.  Does the compression algorithm have some sort of threshold under
which it ignores the --compress switch?

--=20
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

--000000000000e274290649e704ee
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">On Tue, Feb 3, 2026 at 2:51=E2=80=AFAM Ho=
lger Jakobs &lt;<a href=3D"mailto:holger@jakobs.com">holger@jakobs.com</a>&=
gt; wrote:</div><div class=3D"gmail_quote gmail_quote_container"><blockquot=
e class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px s=
olid rgb(204,204,204);padding-left:1ex">Am 03.02.26 um 07:06 schrieb Lauren=
z Albe:<br>
&gt; On Mon, 2026-02-02 at 10:55 -0500, Ron Johnson wrote:<br>
&gt;&gt; Out of curiosity, I opened that dump file in vim, and saw not only=
 DDL strings but cleartext table data.<br>
&gt;&gt;<br>
&gt;&gt; Why isn&#39;t it compressed?<br>
&gt; Are your DDL statement large enough that you would expect that compres=
sing<br>
&gt; them would offer any real advantage?<br>
&gt;<br>
&gt; Yours,<br>
&gt; Laurenz Albe<br>
<br>
That wasn&#39;t the question. It was about why table DATA aren&#39;t compre=
ssed, <br>
but in clear text.<br></blockquote><div>=C2=A0</div></div><div>Exactly.=C2=
=A0 Does the compression algorithm have some sort of threshold under which =
it ignores the --compress switch?</div><div><br></div><span class=3D"gmail_=
signature_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_signature">=
<div dir=3D"ltr">Death to &lt;Redacted&gt;, and butter sauce.<div>Don&#39;t=
 boil me, I&#39;m still alive.<br><div><div>&lt;Redacted&gt; lobster!</div>=
</div></div></div></div></div>

--000000000000e274290649e704ee--