public inbox for [email protected]  

help / color / mirror / Atom feed

From: Ron Johnson <[email protected]>
To: Pgsql-admin <[email protected]>
Subject: Re: Does pg_dump custom format only compress the table data?
Date: Tue, 3 Feb 2026 03:13:37 -0500
Message-ID: <CANzqJaA=e+OgRHtD_W2Ht6ZOu+GY+FZHfLtKWOrGqgkmvVMCpA@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <CANzqJaAiTvMbuTUX86vZVCUY62KyHPffd_Dt1Po6Jmqv_9A_Bg@mail.gmail.com>
	<[email protected]>
	<[email protected]>

On Tue, Feb 3, 2026 at 2:51 AM Holger Jakobs <[email protected]> wrote:

> 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?

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

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Does pg_dump custom format only compress the table data?
  In-Reply-To: <CANzqJaA=e+OgRHtD_W2Ht6ZOu+GY+FZHfLtKWOrGqgkmvVMCpA@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox